Populating a calendar from a spreadsheet

Hi There

I am a complete excel novice and what I'm after is way beyond my capabilities so hoping someone can help me!!

I have a spreasheet with x2 tabs, one displaying a full year calendar and one containing a spreadsheet. I am trying to cross reference the info from the spreadsheet to populate the calendar. I've attached the spreadsheet i'm working from but what i would like is For the calendar to populate with the dates the show is running (columns D-E) state the name of the show (column A) and its location (column c) , also to state the size of the stand (column I). Then if it can be colour coded ie green for confirmed and yellow for tbc (column O)?

Many thanks, any help welcomed but i don't even know where to start in excel help (think i might book myself onto an excel course!!)

This might not be the answer you wanted to hear, but I think using VBA would be the best option here. The reason I say this is because I suspect it's possible for there to be multiple shows on a single date, in which case using a single formula in a cell would get unnecessarily complicated. I understand that you're new to Excel, but if you plan on using it extensively, I strongly recommend you familiarize with VBA. Just take a few hours one of these days and buckle down with a good tutorial.

Here's the basic algorithm I recommend using to solve your problem:

For each cell in the calendar:
1) Find the date it corresponds to (ex. the 26th cell in the March column should return 3/26/2012).
2) For each row in the second worksheet (tab):
Check if the date from step 1 falls between the dates in the current row. If it does, add the desired information from the current row to the current cell being looked at

Does that make sense? I'd be happy to provide code for you if you're interested in this approach.

Hi, thanks for your response. It makes sense but I'm really not sure how to appraoch it? If it helps there will never be a show on the same day

Thanks for your help