Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy worksheet from one workbook to a master workbook
I have a master workbook that has multiple worksheets. each worksheet has a
companion workbook. Currently, I open the companion workbook and manually copy from workbook to workbook. Is there a way to create VBA process or series of macros to open each companion workbook and copy the worksheet to the master? Each companion workbook only has one worksheet, same name as the workbook |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy worksheet from one workbook to a master workbook
You can find code here to do this
http://www.rondebruin.nl/fso.htm Download the example workbook if you want it easy -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mvannatta" wrote in message ... I have a master workbook that has multiple worksheets. each worksheet has a companion workbook. Currently, I open the companion workbook and manually copy from workbook to workbook. Is there a way to create VBA process or series of macros to open each companion workbook and copy the worksheet to the master? Each companion workbook only has one worksheet, same name as the workbook |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy worksheet from one workbook to a master workbook
Thanks, works great!
"Ron de Bruin" wrote: You can find code here to do this http://www.rondebruin.nl/fso.htm Download the example workbook if you want it easy -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mvannatta" wrote in message ... I have a master workbook that has multiple worksheets. each worksheet has a companion workbook. Currently, I open the companion workbook and manually copy from workbook to workbook. Is there a way to create VBA process or series of macros to open each companion workbook and copy the worksheet to the master? Each companion workbook only has one worksheet, same name as the workbook |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy worksheet from one workbook to a master workbook
Thanks, works great!
"Ron de Bruin" wrote: You can find code here to do this http://www.rondebruin.nl/fso.htm Download the example workbook if you want it easy -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mvannatta" wrote in message ... I have a master workbook that has multiple worksheets. each worksheet has a companion workbook. Currently, I open the companion workbook and manually copy from workbook to workbook. Is there a way to create VBA process or series of macros to open each companion workbook and copy the worksheet to the master? Each companion workbook only has one worksheet, same name as the workbook |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save Worksheet To Master Workbook | Excel Discussion (Misc queries) | |||
Update worksheet from Master workbook | Excel Discussion (Misc queries) | |||
Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
How do I set up a Workbook with a master compiled worksheet and o. | Excel Worksheet Functions |