How do I create Dynamic Auto Filter for deficiencies in inventory

New Contributor

I have created an inventory with multiple WorkSheets. all of these worksheets have the same conditional formatting and create highlighting based on the inventory.


I have thousands of items across the worksheets. I want to have another worksheet that all of the deficient items get auto filtered into so that I have a continuous running list of what needs to be ordered.


what is the best way to accomplish this. 

Below is an example of my inventory

Screen Shot 2019-06-08 at 11.34.32 AM.png

2 Replies
I suggest avoiding conditional formatting as a basis of whether an item is deficient. Instead, you may insert a “Deficient” column in each of the sheets, under which is a “Yes” or “ No” entry. Thereby, you can use the summary sheet to show only the deficient items (those with “Yes” under the “Deficient” column).
this wont be able to happen. I need to create some kind of filter