DJRenegade
New Member
- Joined
- Nov 7, 2002
- Messages
- 6
Is there an easy way to autofill cells when referencing multiple sheets, without having to change each sheet reference in the cells.
i.e In my workbook every sheet represents a day in the month. The 32nd sheet summarizes the stats from the sheets. All 31 sheets are laid out identically.
In my summary sheet column A are dates in the month Column B will refrence Cell D3 to the corresponding date.
i.e In my workbook every sheet represents a day in the month. The 32nd sheet summarizes the stats from the sheets. All 31 sheets are laid out identically.
In my summary sheet column A are dates in the month Column B will refrence Cell D3 to the corresponding date.