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!