Right-click on the worksheet tab, not on a cell within the sheet.
--
David Biddulph

"Robin Chapple" wrote in message
...

Gord.

"Move or Copy" does not appear as an option. "Copy" is there but that
is what I did already.

Robin

On Wed, 01 Aug 2007 18:04:05 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Robin

The "worksheet" with 12 months is just a single worksheet in a workbook?

If you copied just the data from that sheet to a new sheet, the page setup
will
not go with.

Suggest you right-click on original sheet and "move or copy"

Checkmark "create a copy" and designate where to place it.

EditReplace old year dates with new year dates.


Gord Dibben MS Excel MVP

On Thu, 02 Aug 2007 10:38:47 +1000, Robin Chapple

wrote:

I have a worksheet which covers twelve months. I have copied it to a
new worksheet for the new fiscal year.

I have lost the page setup.

Is there a way to copy this as well?

Thanks,

Robin Chapple