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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

formula for displaying only the last entry of a group of cells 2
display last entry into a cell automatically 2
Go to cell below last entry in column and total 1
First, Last occurance of date in column 5
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
How to make a cell show average of the last 5 entries in a column? 1
An old chestnut: finding the last cell in a range 10
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

Back
Top