Autofilter question

[jamief]

Hey guys,

I have a macro that pulls all the data based on a code in a drop down menu. It works perfectly right now, but I want to edit it a bit.

This matches the code in cell B3 of the "Check Sheet" sheet to a code in F:F of the Inventory sheet. What I want to do, is on the inventory sheet there are some rows that just have areas of the inventory like "Prep hall" "Cooler" etc.

I want for it to pull those lines too, for every category code. So I could write all the numbers in the F:F cell, and if it could search the contents of the cell, that would work, or have it pull if the cell is blank also.

End goal would be

-Inventory Category-
product
product
product
-Inventory Category-
product

Thanks!!!!

Please Login or Register  to view this content.