Thread: Date display
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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