Displaying a list of values
 

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!
--
Thank you
MFK

Displaying a list of values
 

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
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"MFK" wrote:

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!
--
Thank you
MFK

Displaying a list of values
 

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.


--
Kevin Backmann


"MFK" wrote:

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!
--
Thank you
MFK