Hello,

I am looking to use excel to auto-populate a few calendars. They are marketing based. I'd like to be able to input all information on one sheet (i.e. run date, vendor, ad title, cost, and a few other items) and then have a calendar pre-fill that shows which ads are running on given dates. I tried using a vlookup and got it to work except for the problem of multiple ads running on the same day.

once the calendar would populate id like to get a weekly, monthly and YTS cost totals.

On other pages i would like to just filter things by say ad or sponsorship and show a running list of the items, but the calendar is where i am really hung up.


I've attached a copy some data and potential layout.

Thanks for any help you may be able to provide.

Copy of 2012 Budget for Marketing.xls