| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to copy the contents from last cell
I have a column of data but I do not know how many cells in column. I want
to copy the last cell from this column. e.g. Example 1 ======== A1 = 412 A2 = 343 A3 = 434 A4 = <empty A5 = 3432 A6 = 34 A7 = 3431 A8=<empty A9=<empty ..... and so on cells are empty .... .... I want B1 = 3431 (A7) because it is the last cell with non empty content Example 2 ======== A1 = 412 A2 = 343 A3 = 434 A4 = <empty A5 = 3432 A6 = 34 A7 = 3431 A8=123 A9=456 A10=<empty A11=<empty A12=<empty --- and so on cell s are empty... .... I want B1 = 456 (A9) because it is the last cell with non empty content Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cell contents to different page | Excel Discussion (Misc queries) | |||
| copy cell value not contents | Excel Discussion (Misc queries) | |||
| Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
| Help - How to copy word doc contents into a cell | New Users to Excel | |||
| how do I copy the contents of a cell from one workbook to another | Excel Worksheet Functions | |||
Threaded Mode
