YhfyNr9.png

Small set of data - Picture Attached

I have 5 columns with different dates to track when certain items expire per employee. Conditional Formatting is working like a champ but the data is growing.

I'd like a way to 'quick glance' at all my people that are expired, coming up on expired (this month and next).

I was thinking if there was a script to run through all 5 columns, if the date was less than today, throw the 1st,2nd and 5-9 column (in that row) into a new table. That way i can keep my big sheet but have another sheet or table that i can see QUICKLY who all needs to get their stuff up to date.

Hope that makes sense