Autofill dates in a 3D range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook with 53 pages (onepage for each week of the year),
I want to autofill the date of each weekday across all 53 sheets,
 
You you talking about 53 worksheets, each with a tab? If so, Ctrl+Click the
right and left tabs to select them and every tab between. This will Group
the worksheets. Any data entered will now be entered in all. When finished,
click any tab to ungroup (or right-click and choose Ungroup).
 
Back
Top