Date display
 

Hello all,

I am trying to display a date on multiple sheets. I want to be able to
input a date into a cell on the first sheet manually and have the rest
of the sheets in the given workbook update automatically.

I know if I was trying to do this for a cell on the same sheet I could
just put "=cell_N", but can it be done for a cell on a different sheet
of the same workbook?

Thanks in Advance!!!


--
new2XL
------------------------------------------------------------------------
new2XL's Profile: http://www.excelforum.com/member.php...o&userid=35161
View this thread: http://www.excelforum.com/showthread...hreadid=551897

Date display
 

Hi
Just select the cell on the other sheet where you want the date to show,
type = and then click on the date cell on your other sheet.

Hope this helps.
Andy.

"new2XL" wrote in
message ...

Hello all,

I am trying to display a date on multiple sheets. I want to be able to
input a date into a cell on the first sheet manually and have the rest
of the sheets in the given workbook update automatically.

I know if I was trying to do this for a cell on the same sheet I could
just put "=cell_N", but can it be done for a cell on a different sheet
of the same workbook?

Thanks in Advance!!!


--
new2XL
------------------------------------------------------------------------
new2XL's Profile:
http://www.excelforum.com/member.php...o&userid=35161
View this thread: http://www.excelforum.com/showthread...hreadid=551897