Spreadsheet is attached.

I have a macro that right now when you click the command button it will prompt you to select a Zip file from a set location and it will extract the excel sheets from that zip file to a folder on the desktop, delete the unwanted spreadsheets, and then clean up a few columns in each remaining spreadsheet.

I am now trying to add the functionality that will delete certain spreadsheets based on the person selected. For instance If you select User1 and User2 it would delete all spreadsheets except for those that belong to the user(s) selected. Any ideas? I'm new to VBA and am learning as I do it.

Thank you for your time.


reporttest.xlsm