Autofill dates in a 3D range

G

Gibbo

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,
 
J

Jim

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).
 
Top