How about WEEK01, WEEK02, WEEK03.... ?
HTH,
Gary Brown
"Steve Walford" wrote:
Is there any easy way to rename or name worksheets
I have a 52 page spread sheet, each page represents a week and is
named like so
1st January,8th January,15thJanary etc
The date used represents the first day of the week (Monday)
The next year I copy the spreadsheet and delete all the data, but the
date on the page does no correspond to Monday so I have to rename all
the sheets
Is there an easier way
Thanks
|