Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am looking for a macro that would copy a worksheet named "Template" multiple times. It would create a copy of the worksheet "Template" and change the name based on cell reported on range B6:B25 (20 worksheets) of the worksheet "Config". First worksheet would be named based on cell B6, Second worksheet based on cell B7... However, there may not always be 20 worksheets to create as for instance there may only be data on cells from the range B6:B10 (only 5 worksheets). Finally, as a title, cell B5 of the newly copied worksheet would equal the corresponding cell of the "Config" worksheet (on the B6:B25 range) Thanks in adance for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing name of worksheet based on data in cell of another worksheet | Excel Programming | |||
Changing Cell Color based upon value on another worksheet | Excel Programming | |||
Changing cell values based on a worksheet name | Excel Programming | |||
Duplicating Worksheet to 20 sheet workbook | Excel Discussion (Misc queries) | |||
Duplicating worksheet by VBA | Excel Programming |