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