I'm hoping to get some ideas/links of the best way to accomplish the below requirement.
I have a folder that contains roughly 1800 Excel Documents. Each document has data in specific cells that I need to extract.
My requirement is to provide a final dataset that has the following in each row;
Name of the Excel Doc | Contents of Cell A1 for that document | Contents of Cell B3 for that document | Contents of Cell D1 for that document | etc......
So, I would end up wit 1800 +/- rows with the title and the associated Excel Data from each individual file. Hope that makes sense..?