I am doing a renovation of 800 apartments and have an Excel spreadsheet set up so that each unit # is listed column A. Then all of the items that have to be done in each apartment are listed in row 1. What I'd like to have is another spreadsheet that lists the unit numbers of those that have a particular date in one of the cells.
This other spreadsheet is what the contractors see, so that it shows the units to be worked in tomorrow, for example.
Is there a way to do this?
Bookmarks