View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
linikoo linikoo is offline
external usenet poster
 
Posts: 1
Default 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!