Data Design & Filter

[Kevin H. Stecyk]

I am using Vista and Office 7.

I have data that is the analogous form of "Part Numbers" and "Locations". I
have Col A with various "PartNos" and Columns B through K of "Locations".

If Location1 has the specific part number, then the Location cell is "TRUE".
If Location1 is missing the part, then the Location cell is "FALSE".

I would like to use the dropdown filter to select the part number in ColA,
and then show only those locations that are true.

At present, when I select the part number, I see all locations with their
TRUEs and FALSEs. I would like to just see the locations with TRUEs. Is
there a way to do this?

My specific situation does not deal with inventory control. However, this
"inventory example" is analogous to my situation and is easy to explain.

 

[Herbert Seidenberg]

Excel 2007, Advanced Filter
Drop-down driven Event Macro.
Edit non-inventory example to suit.
http://www.mediafire.com/file/yzizymwmemm/12_17_09.xlsm

 

[Gord Dibben]

Autofilter?


Gord Dibben MS Excel MVP