VBA Code: copy rows to a new worksheet after putting the date and considering category

[poltorak1]

Hi this i my first thread here and I need some help with creating a VBA code that will copy rows to a new worksheet based on the criteria.

1. First tab is a master tab (worksheet)
2. First row is a header
3. In column B there will be like 6 categories, lets name it cat1, cat2, cat3, cat4, cat5, cat6
4. In columns A I will put the date of calling

When I put the date in column A, I want to automatically copy the entire row to a new tab (worksheet) but considering the category from column B. So if in column B we have cat1 it should be copied to worksheet "cat1"

Your help will be appreciated

 

[JLGWhiz]

This assumes that column B data is an exact match for each of your worksheet names. If not, the code fails.
The code should be copied and pasted into the sheet code module. It will run when entries are made in colujmn A.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Or Target = "" Then Exit Sub
    If Not Intersect(Target, Range("A:A")) Is Nothing Then
        Target.EntireRow.Copy
        Sheets(Range("B" & Target.Row).Value).Cells(Rows.Count, 1).End(xlUp)(2).PasteSpecial xlPasteValuesAndNumberFormats
        Application.CutCopyMode = False
    End If
End Sub

 

[poltorak1]

This assumes that column B data is an exact match for each of your worksheet names. If not, the code fails.
The code should be copied and pasted into the sheet code module. It will run when entries are made in colujmn A.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Or Target = "" Then Exit Sub
    If Not Intersect(Target, Range("A:A")) Is Nothing Then
        Target.EntireRow.Copy
        Sheets(Range("B" & Target.Row).Value).Cells(Rows.Count, 1).End(xlUp)(2).PasteSpecial xlPasteValuesAndNumberFormats
        Application.CutCopyMode = False
    End If
End Sub

Thats perfect. Thanks man!

 

[JLGWhiz]

Thats perfect. Thanks man!

You're welcome.
Regards, JLG