Lact cell data copied
 

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

Lact cell data copied
 

Sorry the second line 20 should read line 21

"Malcolm McMaster" wrote:

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

Lact cell data copied
 

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

Lact cell data copied
 

=LOOKUP(2,1/(A1:A100<""),A1:A100)


"Malcolm McMaster" wrote:

Sorry the second line 20 should read line 21

"Malcolm McMaster" wrote:

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

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


.

Lact cell data copied
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Malcolm McM" <Malcolm wrote in message
...
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


.