View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cottage6 cottage6 is offline
external usenet poster
 
Posts: 108
Default Add new sheets with week ending dates

Is there a way I can add 51 new sheets to a workbook that names those sheets
with a week ending date? Sheet 1 is currently names WE 110604; I would like
an additional 51 sheets with each new week ending date. Sheet 2 would be WE
111304, Sheet 3 would be WE 112004, and so on. I appreciate the help, thanks!