Copy rows to other sheets (depending on certain reference column)

Hi Guys!

PLEASE advise! I have an excel doc with several sheets. The first sheet (MAIN) contains ALL info on our inventory.. (dates, categories, costs, etc)

On this main sheet is a dropdown list where you specify a category for each "line" or item (row)...

My aim is to create a sheet for every category and pull only the rows relevant to that category to a specific sheet. (There is 6 categories)

In other words. One sheet to contain ALL info, and also a breakdown (per sheet) per category.

THANKS IN ADVANCE and look forward to a reply!

It would be better keep all the reference data in a single sheet.
Create small function to get the column headers to reach correct item list. loop it based the category to populate the result in the relevant sheet(s)

sample function

Function getCol(ColumnName As String) As Long
    Dim cell
    With wb.ActiveSheet
        For Each cell In .Range(.cells(1, 1), .cells(1, .Columns.Count).End(xlToRight))
            If cell.Value = ColumnName Then
                getCol = cell.Column
                Exit Function
            End If
        Next cell
    End With
End Function

this will retrun the column number
hope it will help you in some way

THANKS SO MUCH for your input!

Ill play around with that a bit!