Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to copy many workbooks into 1 workbook
i have a folder with over 400 workbooks (1 worksheet per workbook). i want
to copy these workbooks into a single workbook with 400 tabs. is there a fast way to do this? say a macro? thanks in advance -- aprilshowers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
want to copy many workbooks into 1 workbook
Check out the copy paste merge examples from Ron's site...
http://www.rondebruin.nl/tips.htm -- HTH... Jim Thomlinson "april" wrote: i have a folder with over 400 workbooks (1 worksheet per workbook). i want to copy these workbooks into a single workbook with 400 tabs. is there a fast way to do this? say a macro? thanks in advance -- aprilshowers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
HOW DO I COPY AND RENAME A WORKBOOK LINKED TO OTHER WORKBOOKS | Excel Discussion (Misc queries) | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
copy selected tabs from multiple workbooks to a new workbook | Excel Worksheet Functions |