Lact cell data copied

  • Thread starter Thread starter Malcolm McMaster
  • Start date Start date
M

Malcolm McMaster

Need some help on a basic question.
I have a list of constantly growing data & I would like the last entered value
in this list to copied to a fixed cell.
EG, if the last entered cell was say line 20 with value "A64" I would like
this value
to be posted to say A1 and as data is entered in line 20 this value would
replace
the contents of cell A1,make sence ?
Any help would be appreciated
 
if the last entered cell was say line 20 with value "A64"

Ok, so I assume the data is TEXT.

Try this...

=LOOKUP("zzzzz",A2:A100)

Adjust for a reasonable end of range A100.
 
Thanks for the help,

T. Valko said:
Ok, so I assume the data is TEXT.

Try this...

=LOOKUP("zzzzz",A2:A100)

Adjust for a reasonable end of range A100.

--
Biff
Microsoft Excel MVP





.
Click to expand...
 
Back
Top