Copy range if column N is empty
Here is a revision for Sub Terranean for you to try...
Sub Terranean()
Dim LastRow As Long
LastRow = Sheets("Carryovers").Cells.Find(What:="*", _
SearchOrder:=xlRows, SearchDirection:=xlPrevious, _
LookIn:=xlValues).Row
On Error Resume Next
Intersect(Sheets("Sales").Columns("A:T"), Sheets("Sales"). _
Columns("N").SpecialCells(xlCellTypeBlanks). _
EntireRow).Copy Sheets("Carryovers").Cells(LastRow + 1, "A")
End Sub
--
Rick (MVP - Excel)
"ajm1949" wrote in message
...
Hi Rick
Sorry I wasn't clear enough.
The Sub Terranean macro is the quickest but we need to put the data after
some existings data. That's the one that I hope can be modified.
Also need a macro to clear data from the carryover sheet where column N
has
a value. This macro will be run before the one to move the data from
sales.
Cheers
Alan
|