Lact cell data copied
Thanks for the help,
"T. Valko" wrote:
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.
--
Biff
Microsoft Excel MVP
"Malcolm McMaster" wrote in
message ...
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
.
|