Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help creating a macro that will create new workbooks from a
defined list of selected worksheets in master workbook. Example is explained below, based on the following table in cells A1:B6, with range called List_WSName in A2:A6 Wsheet Name New Workbook Name WSheet01 NewWB01 WSheet02 NewWB01 WSheet03 NewWB02 WSheet04 NewWB03 WSheet05 NewWB02 so based on the above data, the macro should create 3 new workbooks : (1) NewWB01 would contain copies of WSheet01 & WSheet02 (2) NewWB02 --------------"------------ WSheet03 & WSheet05 (3) NewWb03 --------------"------------ WSheet04 Any help greatly appreciated Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy selected mulitple worksheets to mulitple new workbooks | Excel Programming | |||
Copy selected mulitple worksheets to mulitple new workbooks | Excel Programming | |||
Creating mulitple workbooks from single workbook - *Macro tweaking needed* | Excel Programming | |||
Automatically copy macro to multiple workbooks? | Excel Programming | |||
macro: copy multiple workbooks to multiple tabs in single book | Excel Programming |