spectraflame
Well-known Member
- Joined
- Dec 18, 2002
- Messages
- 829
- Office Version
- 365
- Platform
- Windows
I am using the following formula to reference a cell from another sheet.
='G:\Water\WTP DAILY REPORTS\2011\[10-October 2011.xls]1'!$AD$5
The sheet being referenced contains a tab for each day of the month. The desired value is in the same cell on each sheet. Is there a way that I can update the 1' for each day of the month without having to manually update it?
='G:\Water\WTP DAILY REPORTS\2011\[10-October 2011.xls]1'!$AD$5
The sheet being referenced contains a tab for each day of the month. The desired value is in the same cell on each sheet. Is there a way that I can update the 1' for each day of the month without having to manually update it?