Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: can I refer to cell reference in page setup header | Excel Worksheet Functions | |||
Data in cell to reference a worksheet page | Excel Worksheet Functions | |||
sheet tabs as page number and in a cell page of pages? | Excel Discussion (Misc queries) | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
Reference an identical cell on a different page using copy/paste? | Excel Worksheet Functions |