Excel drop down list with criteria for list

February 9, 2012 at 23:45:02
Specs: Windows 7
Hello everyone!!

I made a flexible list, that will grow / shorten if items are added / removed. The data for this list is on tab1 and is used as a drop down list on tab2.

What I would like to achieve is to have a flexible list, with only specific data: Only the campaigns that are active, should be shown in the list.

This is my data source on tab1:

Name Campaign Active?
Campaign1 Yes
Campaign2 Yes
Campaign3 No

So the drop down list on tab2 should show:


And all this holding in mind the list has to remain flexible.

Thank you all in advance for your help,

See More: Excel drop down list with criteria for list

Report •

Report •

February 13, 2012 at 03:37:26
Thank you for your response, but that is not the answer I'm looking for. Maybe if I explain again:

On Sheet1 I have my data that will serve for my dropdownlist on Sheet2. The data is structured as:

Name Campaign Active?

Campaign 1 Yes
Campaign 2 No
Campaign 3 Yes

On Sheet 2, I would like my dropdownlist to show only the campaigns that are active. In this case it should be:

Campaign 1
Campaign 3

For the moment I have all campaigns, active and non active. That gives me:

Campaign 1
Campaign 2
Campaign 3

But like I said, I add other campaigns to my list on Sheet 1. So my dropdown list is flexible (if I add a row with Campaign 4 on Sheet 1, the dropdownlist on Sheet 2 will automaticaly contain also Campaign 4).

I would like to keep the flexibilty, but "throw out" the non-active campaigns out of my dropdownlist on Sheet 2.

Report •

February 13, 2012 at 05:50:03
I would think that you could do this, but I don't have time to test it right now. Give it a shot and let me know.

1 - Create an Advanced Filter with Criteria, using "Yes" as the criteria.
2 - Use a Dynamic Named range for the range where the Filtered List will be placed.
3 - Refer to the Named Range for your Drop Down.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

February 15, 2012 at 23:25:34
Thank you. That's a very good idea. If I just could make the advanced filter work !! (Never used one before) Thank you, I'll keep you posted if I get how to apply the advanced filter

Report •

February 15, 2012 at 23:31:19
Owkay for the moment I'm using a "normal" filter. Added a colum with the criteria and than I filter on that criteria. That's not really the solution I'm looking for. But it will do fine untill I figure out the advanced filter thing ;)

Report •

Ask Question