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

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.

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

In Sheet 2 cell A1, use the formula =Sheet1!A1+1
and similarly for the other sheets.
--
David Biddulph

"t.cox" wrote in message
...
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.

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

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
"t.cox" wrote in message
...
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.