View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Moving last info in column of worksheet to another in same workboo

The following macro will copy the last entry in column B of Sheet1 to cell A1
in Sheet2:

Sub moveitover()
Sheets("Sheet1").Activate
n = Cells(Rows.Count, "B").End(xlUp).Row
Cells(n, "B").Copy Sheets("Sheet2").Range("A1")
End Sub

you can get a similar result without VBA if you are willing to use a linking
formula rather than copy/paste.
--
Gary''s Student - gsnu200756


"sodat96" wrote:

Hi -
I am sure this is easy, but I am not savvy with macros and programming in
excel to figure this one out.
What I need to do is to take the last date entered in a column of one
worksheet and "copy" it to into another worksheet of the same workbook. I
also need to do that with the last amount (currency formatted) of a column.
There are blank cells in the column depending on weather or not there is
information entered in that particular cell or not.

Any help would be appreciated. Thanks
--
sodat96