|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:
For the moment I have all campaigns, active and non active. That gives me:
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.