Hello,

I am searching for a way to create a workbook that has first sheet as a master list then additional lists that match each department-ie: Administration, Labor, Maintenance, Shipping and Tracking. I would like to have it pull the same info in the entire row over to the appropriate sheet for its department but note some products have 2 departments they would be pulled to. I would need to have the workbook be dynamic as the master list will be updated/changed and those changes would automatically pull to the appropriate sheets. My example below is an idea of how the master list would be then have corresponding sheets for each department of course. The actual list I am trying to create would have thousands of products with their independent information which is why I'm trying to find how to create such a formula(s) to make this workbook happen as the supplies changes over time.

Any assistance would be wonderful!! 

Inv. ID	Product	Manf #	Manufactuerer	Description	Department
1	Red	00-0001	Company R	Product is Red	Labor
2	Blue	00-0002	Company B	Product is Blue	Shipping & Tracking
3	Green	00-0003	Company G	Product is Green	Administration
4	Yellow	00-0004	Company Y	Product is Yellow	Labor, Shipping & Tracking
5	Purple	00-0005	Company P	Product is Purple	Maintainance
Please and Thank you! J.J.

Excel 2010 with free Power Query Add-In.
Compatible with Office 2013 Pro Plus.
No formulas, no VBA macro.
List products with multiple departments.
Separate list for each department.
Dynamic.
http://www.mediafire.com/view/jxyzerp45q14hbr/07_14_15a.xlsx

I am not sure what this is but it does not solve the problem of what I am trying to create.

You might want to share your reduced, sanitized file,
along with a description of the problems you ran into
when you attempted to create a solution.
Show your Excel IT Pro version,
your attempted work,
and your desired solution in text format.

This was accomplished by using an array formula.