Hi,
I have 400 spreadsheets all in the same format. I'd like to consolidate them all in to one without having to copy and paste each one to a master sheet.
Is there a quicker way to do this? All Spreadsheets would be in one folder.
many thanks
Jon
Printable View
Hi,
I have 400 spreadsheets all in the same format. I'd like to consolidate them all in to one without having to copy and paste each one to a master sheet.
Is there a quicker way to do this? All Spreadsheets would be in one folder.
many thanks
Jon
This seems to work OK
http://www.rondebruin.nl/win/addins/rdbmerge.htm