Home

How do I create Dynamic Auto Filter for deficiencies in inventory

%3CLINGO-SUB%20id%3D%22lingo-sub-678895%22%20slang%3D%22en-US%22%3EHow%20do%20I%20create%20Dynamic%20Auto%20Filter%20for%20deficiencies%20in%20inventory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678895%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20an%20inventory%20with%20multiple%20WorkSheets.%20all%20of%20these%20worksheets%20have%20the%20same%20conditional%20formatting%20and%20create%20highlighting%20based%20on%20the%20inventory.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20thousands%20of%20items%20across%20the%20worksheets.%20I%20want%20to%20have%20another%20worksheet%20that%20all%20of%20the%20deficient%20items%20get%20auto%20filtered%20into%20so%20that%20I%20have%20a%20continuous%20running%20list%20of%20what%20needs%20to%20be%20ordered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhat%20is%20the%20best%20way%20to%20accomplish%20this.%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20an%20example%20of%20my%20inventory%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117522i5FC079EF18C513C2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screen%20Shot%202019-06-08%20at%2011.34.32%20AM.png%22%20title%3D%22Screen%20Shot%202019-06-08%20at%2011.34.32%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-678895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678996%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20create%20Dynamic%20Auto%20Filter%20for%20deficiencies%20in%20inventory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678996%22%20slang%3D%22en-US%22%3EI%20suggest%20avoiding%20conditional%20formatting%20as%20a%20basis%20of%20whether%20an%20item%20is%20deficient.%20Instead%2C%20you%20may%20insert%20a%20%E2%80%9CDeficient%E2%80%9D%20column%20in%20each%20of%20the%20sheets%2C%20under%20which%20is%20a%20%E2%80%9CYes%E2%80%9D%20or%20%E2%80%9C%20No%E2%80%9D%20entry.%20Thereby%2C%20you%20can%20use%20the%20summary%20sheet%20to%20show%20only%20the%20deficient%20items%20(those%20with%20%E2%80%9CYes%E2%80%9D%20under%20the%20%E2%80%9CDeficient%E2%80%9D%20column).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-680058%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20create%20Dynamic%20Auto%20Filter%20for%20deficiencies%20in%20inventory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680058%22%20slang%3D%22en-US%22%3Ethis%20wont%20be%20able%20to%20happen.%20I%20need%20to%20create%20some%20kind%20of%20filter%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
cybrnitro
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
Highlighted
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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies