I have multiple spreadsheets that are emailed to a specific address and stored to a file folder. All of these sheets will contain slightly different headers, however, every spreadsheet will at least have a common identification attribute.
Is there a way I can build a workbench to read through all of these excel files to search and extract this ID number from all excel files?
Thanks in advance for your suggestions!
Best answer by jeroen
View original