Hi All,
I've got this far, but when the row is cut from the first sheet and pasted into the next it just over rights the last row pasted there instead of pasting the next row down, any help resolving this would be MUCH appreciated. Thanks. Adam.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Column = 10 And Target.Cells.Count = 1 Then
Target.EntireRow.Copy Destination:=Sheets(2).Cells(Rows.Count, 1).End(xlUp).Offset(2, 0)
lastrow = Range("B65536").End(xlUp).Row + 1
Cells(lastrow, 2).Select
Target.EntireRow.Delete shift:=xlUp
Application.EnableEvents = True
Exit Sub
End If
If Not Intersect(Target, Range("F:F")) Is Nothing Then
Target.Offset(0, 1) = Date
End If
Application.EnableEvents = True
End Sub
Bookmarks