Please see attached sample spreadsheet. I am trying to find the correct formula that will scan the info in 'Test' worksheet and copy the corresponding row of information from 'Test' worksheet to the correct '<Days' worksheet based on the date in Column I. So, if the date in column I is less than 30 days from today, then copy that row to the corresponding sheet, etc. Any help is greatly appreciated.

Attached Files

Copy of G3 CUOPS Task Tracker.xlsx (44.1 KB, 11 views)

Is it like the attached?

Attached Files

G3 CUOPS Task Tracker_2.xlsx (69.8 KB, 10 views)