Macro to make multiple copies of a formatted worksheet

T

Tim at alliant

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
 
T

Tim at alliant

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top