Automatically update a given cell

[picktr]

I would like to automatically update a given cell, ex: C:1,
with whatever I put into any given cell within a range

ex range D3:Z3
today I enter the number 3 into D3
C:1 is updated to reflect the number 3
tommorrow I enter the number 8 into E3
C:1 now is updated to reflect the number 8
the numbers would be entered in succeeding cells , within the range,
with no cells skipped.
Any help would be appreciated.

Thanks

Tom (e-mail address removed)

 

[Earl Kiosterud]

Tom,

=OFFSET(D3,0,COUNTA(D3:Z3)-1,1,1)

 

[picktr]

Thanks you for your help!

Tom Picket