Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lact cell data copied
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied formula produces unexpected copied results | New Users to Excel | |||
How do I prevent data i a cell from being copied? | Excel Discussion (Misc queries) | |||
Remove ' character from copied excel cell to match data | Excel Discussion (Misc queries) | |||
Excel automatically copied data from one cell to another... | Excel Discussion (Misc queries) | |||
can i convert data copied as an image into data in excel ? | Excel Worksheet Functions |