format multible worksheets in a workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Thanks
 
In sheet 2 put =Sheet1!A1+7 and in sheet 3 put =Sheet1!A1+14 or =Sheet2!A1+7
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
Eric said:
I need to know how to format worksheets in a workbook and have them
Click to expand...
reconize "3-d" cell references.
i.e. cell a1 on sheet 1 is todays date, need to have cell a1 on sheet 2
Click to expand...
read the date 7 days later, sheet 3 another 7 days etc.
 
Here's a thread that shows two different approaches:

http://tinyurl.com/ywpb8
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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

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

Thanks
 
Back
Top