listing active campaigns

[Sethrow]

Ok I have a very long list of campaigns that have start and end dates these are stored in sheet2. The important data is column A has name column B has start date and column C has end date.

I want sheet1 to list only the campaigns that are active, ie where the current date is between the start date and the end date.

Anyone got any ideas?

Also I want it to update everytime I open the file, is this possible? If so how?

Many thanks

Seth

P.So There is more to this problem but I think if get this bit then I should be alble to get the rest working! But don't be surprised if there are follow up questions lol

 

[Sethrow]

Thanks I think I understand a bit better although not fully lol