If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 news 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
|
|||
|
|||
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 news 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
|
|||
|
|||
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 news 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 |
Thread Tools | |
Display Modes | |
|
|