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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill list 2
Autofill in 2007 10
Week Number Format 4
Autofill defaults 4
HELP!!! I need macro to autofill 4
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Autofill column values in formulas 4
Autofill Dates Through Worksheets? 2

Back
Top