Return to Combo Box with Ranges Lists

[nytwodees]

I have 1 Combo Box drop down in which I want the selection in the Combo Box to then access the criteria to filter my worksheet. Below is a picture of small table that corresponds to the selection made in the Combo Box. This criteria is a range of values for each selection in the Combo Box to filter my rows in the worksheet.

Combo Box Info.jpg

Column A shows the items in the Combo Box.
Columns B And C shows the filter criteria for each selection

So as an example, if the end user chooses "Range from 1 to 500" from the drop down, the criteria would be the range: from Crit1 to Crit2: the criteria range for filtering the worksheet would be from 1 to 500.

My problem is I don't know how to link the text items to its corresponding criteria to do the actual filtering of the worksheet.

[Vraag en antwoord]

Apparently missed the big yellow banner. We can't do much with a picture.

[nytwodees]

Attached is the worksheet.

[nytwodees]

Attached is the worksheet.
Attached Files Attached Files
File Type: xlsm Combo Box Sample.xlsm‎ (22.4 KB, 2 views) Download

or see my earlier post with the worksheet attachment.

Are there NO geniuses out there?!

[torachan]

The reason you probably have had no answer is there appears no apparent connection between your initial request and the attached file
A little more clarity might get a response.

[nytwodees]

Let me completely restart my post.

I am trying to create a Combo Box dropdown that will search and filter a range in my table.

"Normally" the list DISPLAYED in the Combo Box dropdown has a dual function:
1. It DISPLAYS all the possible choices that are allowed to be selected.
2. Its 2nd function, the selection chosen also acts as the FILTER for your table.

The Combo Box dropdown I am trying to create fulfills the DISPLAY function only. I need a way for the DISPLAY function chosen to then FILTER using a range that is ASSOSCIATED with the DISPLAY item I chose. I do not know how I can be any clearer.

BTW: My Combo Box dropdown is an Active X control - but perhaps this is not necessary.

Attached is a sample worksheet. NOTE: The sample worksheet is attached above. For some reason I cannot add the attachment in this post.

[Vraag en antwoord]

Maybe something like this. I have made some adjustments, but you will see them automatically.

[torachan]

@ Vraag. does your submission bear any semblance to the query in post #1

[Vraag en antwoord]

@torachan,
Seems to me. Filter for certain criteria that are in a combobox. The file differs from the initial question, but that is more common

[nytwodees]

@torachan,
Seems to me. Filter for certain criteria that are in a combobox. The file differs from the initial question, but that is more common

Please ignore post #1.

My computer is out for repair with Dell at the moment, so I can open your file without the use of the Active X controls.

However, from what I see you utilized the "Advanced Filter" approach. Yes, that works, but it is not the most "user friendly" approach. I do not want the end user to enter any data. As I said, I want the DISPLAY choice to be assosciated with the FILTER for that choice. There are no additional steps required of the end user (except to Apply Filter button). I hope I am clear.

[Vraag en antwoord]

I have shown you the technique of splitting. What else you do with it is up to you

[nytwodees]

I have shown you the technique of splitting. What else you do with it is up to you

Since I cannot see your file correctly because my computer with Excel 2010 is out for repair. Free versions of Excel (which I am compelled to use now) do NOT allow use of macros or Active X controls which are contained in both mine and your worksheets.

I am not sure what you mean by the "technique of splitting." The bottom line is, does your technique accomplish the "user friendly" approach I described in my previous post. Is the answer YES or NO?

[nytwodees]

I finally got my computer back from Dell repair. Attached is my unprotected file. The only combo box that does not work is the Total Number of Hospital Beds. This is the ONLY combo box that have choices which have ranges. This is where I need your help.