I found this code in this forum which works great but now I want the values to be CUT to the next column instead of copying them. Any help would be appreciated.
![]()
Private Sub Worksheet_Change(ByVal Target As Excel.Range) On Error GoTo stoppit For Each cell In Application.Intersect(Range("E2:E50"), Target) n = Target.Column ActiveSheet.Cells(Rows.Count, n).End(xlUp) _ .Offset(0, 1).Value = Target.Value Next stoppit: End Sub
Bookmarks