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