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

[henco8]

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!

[balajim]

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

Please Login or Register  to view this content.

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

[henco8]

THANKS SO MUCH for your input!

Ill play around with that a bit!