Thread: Move the last entry in a column to a different cell, when the loc.

I am running a column of decending and assending numerical values and I am
not sure which cell will contain the last entry. However, when the last
numerical figure posts, I need to move this value to another cell location,
automatically. What function can I use to obtain this result? There are blank
cells between the last entry in the column and the desired cell, of
destination. Rather then Copy & Paste. The location and value of the last
entry in a column may vary from month to month, but it is important to
relocate this amount to a new destination cell. I am unaware of any function
that will give me the desired results.

Hi

If you want to copy you need a macro
This will copy the last cell in column A in "sheet1" to A1 in "sheet2"

Sub test()
Sheets("sheet1").Range("A" & Rows.Count) _
.End(xlUp).Copy Sheets("sheet2").Range("A1")
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl



"MicroSoft Excell (?)" <MicroSoft Excell (?)@discussions.microsoft.com>
wrote in message news:17692C25-8D5C-4031-991E-F744F54C005D@microsoft.com...
>I am running a column of decending and assending numerical values and I am
> not sure which cell will contain the last entry. However, when the last
> numerical figure posts, I need to move this value to another cell
> location,
> automatically. What function can I use to obtain this result? There are
> blank
> cells between the last entry in the column and the desired cell, of
> destination. Rather then Copy & Paste. The location and value of the last
> entry in a column may vary from month to month, but it is important to
> relocate this amount to a new destination cell. I am unaware of any
> function
> that will give me the desired results.

Is the destination cell in the same column as your numbers? If not, and
there is no other number below the last entry you refer to, then you can use

=LOOKUP(9.999E+307,A:A) for last numeric entry in column A

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"MicroSoft Excell (?)" <MicroSoft Excell (?)@discussions.microsoft.com>
wrote in message news:17692C25-8D5C-4031-991E-F744F54C005D@microsoft.com...
> I am running a column of decending and assending numerical values and I am
> not sure which cell will contain the last entry. However, when the last
> numerical figure posts, I need to move this value to another cell
location,
> automatically. What function can I use to obtain this result? There are
blank
> cells between the last entry in the column and the desired cell, of
> destination. Rather then Copy & Paste. The location and value of the last
> entry in a column may vary from month to month, but it is important to
> relocate this amount to a new destination cell. I am unaware of any
function
> that will give me the desired results.