View Single Post
  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

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