I have a list of about 150 report names (column A) and report paths (column B) in an excel sheet. I need to know if my colleagues still use these reports or if they can be deleted in our computer system. I would like to send each colleague the excel list and have them select which files to keep and which files to delete. I was hoping to achieve this with an added column next to the report name and then their selection could be compiled in another sheet for me to easily see which reports that user selected to keep and which reports that user selected to delete.
What is the best way for me to add a column on each individual sheet with a dropdown or other form field that will be dumped into a cumulative page at the end of the workbook?
I know how to add a dropdown box with "Delete" or "Keep" next to the path name using Data Validation but I do not know how to get this information to populate in another sheet based off their selection.
Hope this makes sense!
Bookmarks