Hey all...Solved as below...thanks xlnitwit
Sub Move()
Application.ScreenUpdating = False
Dim lastRow As Long
Dim TRow As String
TRow = Sheets("Temp").Range("C11")
With Sheets("Hist")
lastRow = .Range("a" & .Rows.Count).End(xlUp).Row
If .Cells(lastRow, "A").Value <> vbNullString Then lastRow = lastRow + 1
End With
With Sheets("Temp")
With .Range("A1").CurrentRegion
.AutoFilter 2, TRow
If .Columns(1).SpecialCells(xlCellTypeVisible).Count > 1 Then
With .Resize(.Rows.Count - 1).Offset(1)
.Copy Sheets("Hist").Cells(lastRow, "A")
.Columns(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
End With
End If
End With
.AutoFilterMode = False
End With
Application.ScreenUpdating = True
End Sub
Bookmarks