Hello Everyone,


Today I present a problem I am certain a solution exist for.

The file is attached below to help better understand the situation.


I have dates in the "Master Table for Dates" which is used to populate schedule #1 by checking to see if the date from the schedule exist in the master table.

Schedule #2 is used to round schedule #1 to a date from the "Master Table for Dates"

Schedule #3 is used to lookup the dates in schedule #2 in order to record the event from "Master Table for Event".


What I am trying to do now is use a macro to lookup the events in schedule #3 with the color table I have above schedule #1 and then place that color and event name into schedule #4.

The macro needs to allow us to then be able to add to the cell, so it can not be an equation. For example SOP (with the cell shaded dull yellow) then we might need to type '6/15/15' next to the 'SOP' that is in the cell.


I am horrible with programing and only have experience with simple macros.

Is there anyone who can accomplish this task?

Any help is greatly appreciated!


Miracle Man needs a miracle.. heheeee :-D