View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim at alliant Tim at alliant is offline
external usenet poster
 
Posts: 9
Default 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