Create multiple copies of a worksheet

Is there an easy way to create multiple copies of a worksheet

Say I create a worksheet for timesheets with no data in it, is it
possible to make 52 copies

Using Excel 2002

Many Thanks

Steve

Hi
you could set this up as a template or use a macro to copy this sheet
within your file

--
Regards
Frank Kabel
Frankfurt, Germany


Steve Walford wrote:
Is there an easy way to create multiple copies of a worksheet

Say I create a worksheet for timesheets with no data in it, is it
possible to make 52 copies

Using Excel 2002

Many Thanks

Steve

Since you mentioned 52 copies, it sounds like you want to open a fresh
timesheet each week. You can create a workbook template from your blank
timesheet, by following the 'Create a template' instructions in Excel's
Help, or he


http://office.microsoft.com/assistan... H062527921033

Steve Walford wrote:
Is there an easy way to create multiple copies of a worksheet

Say I create a worksheet for timesheets with no data in it, is it
possible to make 52 copies

Using Excel 2002


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi


Another way - right-click on sheet tab, Move or copy, check 'Create a copy',
OK, and rename new sheet. Then select both sheets and repeat the procedure
above. Then the same with 4 sheets etc. - with 7 cycles you have your 52
sheets.


--
Arvi Laanemets
(Don't use my reply address - it's spam-trap)


"Steve Walford" wrote in message
...
Is there an easy way to create multiple copies of a worksheet

Say I create a worksheet for timesheets with no data in it, is it
possible to make 52 copies

Using Excel 2002

Many Thanks

Steve

Steve,

It sounds as if you're planning on having a separate sheet for each week of
a year. Here's my standard blurb on this topic.

There's a lot of Excel functionality that isn't available when similar data
is spread across multiple sheets (as well as across multiple workbooks).
Questions abound where users already have data in separate sheets, and now
want to find certain data, summarize the data, etc. and there are no direct
means to do that.

If the layout of the data in the sheets will be the same (same column
headings), it is generally best to put all the data in a single sheet, with
an additional column for what originally was the various sheets. For
example, if you have a sheet for each month, put all the data in a single
sheet, with an additional column for month. An Autofilter can easily
reduce this consolidated sheet to the equivalent of one of the original
(month) sheets. Now you can sort in various useful ways, use Data -
Subtotals, easily make a pivot table to summarize the data, use database
functions (DSUM, COUNTIF, etc.).

If the separate sheets already exist, it's a straightforward one-time
project to combine them. Just make a sheet with the extra (month) column.
Now paste the records from the first sheet, and enter Jan into the month
column and copy down with the fill handle or copy/paste. Repeat for the
other sheets.

I strongly recommend you consider this.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Steve Walford" wrote in message
...
Is there an easy way to create multiple copies of a worksheet

Say I create a worksheet for timesheets with no data in it, is it
possible to make 52 copies

Using Excel 2002

Many Thanks

Steve