| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically compiling many workbooks into one
I'm needing to copy a bunch of information from a bunch of different excel
files into one massive workbook. I'm hoping to avoid having to do that manually. I already tried a macro, but it seems as if macros don't work across multiple files. I don't need to copy all of the information over, but rather information in specific cells. The information is in different worksheets in the files. Does anyone know of anything I could do to make this easier? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically compiling many workbooks into one
Try this:
http://www.rondebruin.nl/copy3.htm Or maybe this: http://www.rondebruin.nl/fso.htm You can find all of Ron de Bruin's tips he http://www.rondebruin.nl/tips.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jor" wrote: I'm needing to copy a bunch of information from a bunch of different excel files into one massive workbook. I'm hoping to avoid having to do that manually. I already tried a macro, but it seems as if macros don't work across multiple files. I don't need to copy all of the information over, but rather information in specific cells. The information is in different worksheets in the files. Does anyone know of anything I could do to make this easier? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing 2 workbooks automatically in Excell | Excel Worksheet Functions | |||
| Compiling information from multiple workbooks and summarizing | Excel Worksheet Functions | |||
| Automatically Collate Workbooks | Excel Programming | |||
| Update multiple workbooks automatically | Excel Worksheet Functions | |||
| Transferring data between 2 workbooks automatically | Excel Programming | |||
Hybrid Mode
