fast way creating multiple worksheets with same format in excel?
 

I have created a table in a worksheet and want to use this same table for
every other worksheet in the same workbook. at first i saved the table as a
template and opened it in a new workbook, but i don't know how to open it up
for other worksheets in the same workbook (if this is possible). I know i can
make a new copy of the worksheet, but i only know how to do it one worksheet
at a time. it will take forever to make 30 pages every month! does anyone
know a faster way to do this? thanks!

fast way creating multiple worksheets with same format in excel?
 

In VBA you can add multiple copies of the same template in one command. Save
your worksheet in a one-sheet template. The syntax you need in VBA is:

ActiveWorkbook.Sheets.Add(Count:=<number to add, Type:=<path and file name
of template)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"linikoo" wrote in message
...
I have created a table in a worksheet and want to use this same table for
every other worksheet in the same workbook. at first i saved the table as
a
template and opened it in a new workbook, but i don't know how to open it
up
for other worksheets in the same workbook (if this is possible). I know i
can
make a new copy of the worksheet, but i only know how to do it one
worksheet
at a time. it will take forever to make 30 pages every month! does anyone
know a faster way to do this? thanks!

fast way creating multiple worksheets with same format in excel?
 

For the OP

More info here if you are new to templates
http://www.rondebruin.nl/sheettemplate.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jon Peltier" wrote in message ...
In VBA you can add multiple copies of the same template in one command. Save
your worksheet in a one-sheet template. The syntax you need in VBA is:

ActiveWorkbook.Sheets.Add(Count:=<number to add, Type:=<path and file name
of template)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"linikoo" wrote in message
...
I have created a table in a worksheet and want to use this same table for
every other worksheet in the same workbook. at first i saved the table as
a
template and opened it in a new workbook, but i don't know how to open it
up
for other worksheets in the same workbook (if this is possible). I know i
can
make a new copy of the worksheet, but i only know how to do it one
worksheet
at a time. it will take forever to make 30 pages every month! does anyone
know a faster way to do this? thanks!