Displaying a list of values

[MFK]

I am trying to create and interactive spreadsheet.
I have different tubing sizes and strengths for each one. I want to install
a drop down menu in the worksheet that you can select a range of tubing
strengths (10-15). Once a range is selected I would like all tube sizes that
strengths are in that range to display. Is this possible?
Please help!

 

[Barb Reinhardt]

You bet. This seems to be a common question. I think I've seen it 3 or 4
times this week.

What you're looking for is a dependent dropdown.

http://www.contextures.com/xlDataVal13.html

 

[Kevin B]

Have you tried DATA/FILTER/AUTO FILTER. It will create drop down buttons for
each of your column heading and you can select what you want to filter from
one or more of the columns.