Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
hi, i am trying to copy data to closed workbook | Excel Programming | |||
Importing data from multiple closed workbooks | Excel Programming | |||
Copy data from a closed workbook (ADO) | Excel Programming | |||
copy data from a closed workbook | Excel Programming |