| 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
=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 |
|
#4
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 |
|
#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 | |||
![Malcolm McMaster[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
