Macro to Copy Mulitple Worksheets to New Multiple Workbooks
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
|