fast way creating multiple worksheets with same format in excel?

L

linikoo

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!
 
J

Jon Peltier

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
 
Top