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!

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!

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!