| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform for displaying values from a row | Excel Discussion (Misc queries) | |||
| Displaying only unique values, PLEASE HELP | Excel Discussion (Misc queries) | |||
| displaying values | Excel Discussion (Misc queries) | |||
| Not Displaying Zero Values | Charts and Charting in Excel | |||
| finding values and displaying adjacent values | Excel Worksheet Functions | |||
Hybrid Mode
