Hey Everyone,
I am trying to tract documents using a spreadsheet, I have 6 different worksheets created each organized by County and one Called "Pending Review". We are going to be sending documents out to different people to be reviewed so I want one worksheet that gets automatically compiled once I enter a date in the column "Date Documents Sent Out" . However, once I receive the documents back I want to enter a date in "Date Documents Received" and have the row be deleted from the "Pending Review".
Basically I want to be able to use "Pending Review" and see exactly what documents are being reviewed without having to look through 7 worksheets.
I have attached my spreadsheet but have deleted the information. If at all possible can someone input a formula for me and send it to me?
Thanks!
Bookmarks