This what I have now. I did change the "J" to and "I" cause I didn't need that many columns![]()
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim sname As String If Range("I" & Target.Row).Value <> "" Then sname = Range("E" & Target.Row).Value Target.EntireRow.Copy Worksheets(sname).Range("A" & Rows.Count).End(xlUp).Offset(1, 0) Target.EntireRow.Delete End If End Sub
Bookmarks