I have a spreadsheet that has several columns for Item Number, Part Number, Description, Where Used. In the Where Used column, I have Product A, Product B, Product C, etc... I want to put a drop down list above the "Where Used" column, where someone would select "Product B", and all rows of Parts that weren't used on "Product B" would be hidden. To get back, in the same drop down list, they would select soemthing like "Show All". Then all rows would be seen again.
I need instructions for Excel 2010.
There are Sorts, Filters, Combo Boxes, List boxes, etc...too much info. Since I don't have intimate knowledge of each type of method, I'm not sure what the best approach is. One thing for sure, is whatever solution you propose, I want to make sure, it doesn't actually sort and change the document, this is only a viewing issue. So I'm thinking a filter might be better but not sure. Please advise