Cell formatting

J

James O

Is there a way that when I enter a date in one cell I can have something
automatically put into another cell. The automatic entery will always be the
same. I am using Excel 2002
 
D

Dave Peterson

You could use a formula that will retrieve the value from that cell:

=a1
or
='Sheet 999'!a1

Or

=if(a1="","",a1)
=if('Sheet 999'!a1="","",'Sheet 999'!a1)

to keep the formula from returning a 0 when the cell is empty.
 
Top