Excel Help to Filter Results based on Drop - Down selection

**ellie388** · 06-24-2013, 06:35 PM

Hi Excel Gurus!

I am looking for help to have data filtered based on the users selection from a drop-down menu. The following thread helped me significantly: http://www.excelforum.com/excel-gene...lter-data.html

Except for, the drop-down menu is based on a validation list from another sheet. So the vba code based on the thread mentioned above doesn't capture this scenario. I am not familiar with vba, so I welcome any feedback and help!

Thanks in advance,

**BobBing** · 06-24-2013, 08:18 PM

Hi Ellie,

Just so I'm clarifying, your sheet is different because you are attempting to use the data filter from another sheet?

I'm sure this is very doable for what you are looking for, but you could just do an alternate solution.
Just link the cell on the main sheet that you want to filter to the drop-down list on your other sheet, so whatever value you choose on the drop-down will populate on the main sheet.
Seeing as it is linked to B1 for you code you could just have B1 be linked and that would filter the data for you based on the option from the other sheet.

**ellie388** · 06-25-2013, 08:21 AM

Hi Bob,

Thanks for your response. Sorry for the confusion in my post.

My sheet is different from the example above because of the following:
- in the example above, the drop-down menu they have is using a "validation list" where the list values are not stored on a different sheet. Rather the list values are just written in the field provided on the validation list window. (they only have 4 or so)
- in my workbook, I have over 180 list values that I want to use for the drop down on the given sheet where the filtering is to occur. So the 180 list values are stored on a separate sheet. The code does not work for this case.

This is the code i'm using (derived from the example I mentioned above):

Please Login or Register  to view this content.

-----
Please note "B3" is where the drop down is and it should correspond with values in column C for the filtering piece.

Please let me know if this is not clear. Thanks again for all the help!

**BobBing** · 06-26-2013, 07:51 PM

Ellie,
Sorry for the slow response, I've been traveling for the past few days.

I am not sure If I am 100% on this still. I do not see how it would make a difference whether you are referencing a list or actually spelling out the variables you are trying to use or the actual amount would impact the filtering code.

Take for example the sheet attached. It is looking at A,B,C,D as the values again, but I have moved the options to sheet2 and called the group of their cells "list".
Going into data validation and the list option and typing in "=list" for cell B1 on sheet1 now references that list which is what I'm assuming you are doing.
As you can see this has not impacted the actual filtering on sheet1.

Can you add an example of your sheet so I can look at your issue first hand?

-Bob