Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to make multiple copies of a formatted worksheet
I have a worksheet template created in Excel 2003 that contains multiple
formulas, lookup tables etc,. Is there a macro that would create from 1 to 100 copies of the template and then also add the total from two fields of all of the new worksheets together? Let's say S10 and S15 for example would need to totaled for all of the new worksheets created. Or is it only possible to copy a preset number of worksheets in a Macro?Thanks. Tim at Alliant |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to make multiple copies of a formatted worksheet
Since I posted this, the powers that be have decided to go in an entirely
different direction so I no longer need this information. Thanks. -- Tim at Alliant "Tim at alliant" wrote: I have a worksheet template created in Excel 2003 that contains multiple formulas, lookup tables etc,. Is there a macro that would create from 1 to 100 copies of the template and then also add the total from two fields of all of the new worksheets together? Let's say S10 and S15 for example would need to totaled for all of the new worksheets created. Or is it only possible to copy a preset number of worksheets in a Macro?Thanks. Tim at Alliant |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple copies of a sheet in a new workbook | Excel Worksheet Functions | |||
make copies of worksheet for each day of month | Excel Discussion (Misc queries) | |||
How can I Make 3 copies of one worksheet Page? | Excel Worksheet Functions | |||
Multiple copies of a template worksheet in one file | Excel Discussion (Misc queries) | |||
printing multiple copies of a worksheet | Excel Discussion (Misc queries) |