Lact cell data copied

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
 
T

T. Valko

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.
 
M

Malcolm McM

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Moving data to another file - help needed 1
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
data from multiple files: best way to extract 1
summarizing data from various workbooks 3
Lock out data entry in a cell 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Text to appear three rows after last blank cell in column 3

Top