Copy Data from Multiple Closed Workbooks to Open Workbook
Is there a way programmatically that I can copy data from multiple
workbooks and append each set of data to an open work book.
Here is the situation I have about 35 large workbooks each containing
data for a market I need to combine all the data so do analysis
throughout all 35 instead of having to search 1 by 1 and then adding up
the data manually.
Any ideas or help would be greatly appreciated.
|