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.


James O wrote:

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

--

Dave Peterson