1) as the new timesheets come in, copy the data from that file into your new master workbook so all data is in an actual database.
2) With titles in row 1, click on that row and turn on the Data > Autofilter
3) Now you can use the column B drop down to select any project and it will display those rows to you, work with those rows (edit, copy, print, etc...)
Then you can change to a different filter or ALL again to return to normal display.
Bookmarks