I am trying to automate a task I am given. So here is the high level overview:
- On an Excel sheet, I have actual numbers of invoices. (they are just line items with the number)
- On a separate folder, I have the files that are literally the same numbers of the invoices in my Excel sheet.
- I want to set it up to where I can run a macro that will check the name of the file in my folder (which is the number of the invoice) to the actual invoice number in my Excel sheet and if they match, just merely select the file in the folder.
- The end result would be: all of the numbers that match should be selected.
Is this possible?