format multible worksheets in a workbook

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Eric (anonymous_at_discussions.microsoft.com)
Date: 05/12/04 

Date: Tue, 11 May 2004 19:11:03 -0700

I need to know how to format worksheets in a workbook and have them reconize "3-d" cell references.
i.e. cell a1 on *** 1 is todays date, need to have cell a1 on *** 2 read the date 7 days later, *** 3 another 7 days etc.

All attempts to do this on the additional sheets keeps referencing sheet 1.

Thanks

Quantcast