Displaying a list of values

M

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!
 
K

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.
 
Top