I have several spreadsheets that are formatted exactly the same and I want to extract data located in the same place on each spreadsheet. Is there a way in vba to accomplish this? I do have the names of each spreadsheet on a separate spreadsheet.
I essentially want to loop through the spreadsheet names, open up each spreadsheet, extract the data and paste it in a table format.
Thanks in advance.
I essentially want to loop through the spreadsheet names, open up each spreadsheet, extract the data and paste it in a table format.
Thanks in advance.