Hi all,
I wonder if anyone has come across this scenario previously :-
I have a series of all spreadsheets all containing the same number of sheets with the data all in the same format. They are all stored in the same folder.
From one other spreadsheet is it possible to open each spreadsheet in the folder (The file names all change but will remain .xls format) and retrieve data accordingly, returning it all to a central spreadsheet?.
Thanks.
I wonder if anyone has come across this scenario previously :-
I have a series of all spreadsheets all containing the same number of sheets with the data all in the same format. They are all stored in the same folder.
From one other spreadsheet is it possible to open each spreadsheet in the folder (The file names all change but will remain .xls format) and retrieve data accordingly, returning it all to a central spreadsheet?.
Thanks.