how to reference a cell on one page to a cell on another page

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

Guest

i would like to make a worksheet with seven pages one for each day of the
week. in a1 on the first page put the date. then have each page automatically
insert the date
on that day.
 
In Sheet 2 cell A1, use the formula =Sheet1!A1+1
and similarly for the other sheets.
 
t cox, use something like this on your other sheets =Sheet1!A1+1...

--
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 2002 & 2003
 
Back
Top