M
Miracle Man
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
+-------------------------------------------------------------------+
|Filename: Program Timing Table.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=915|
+-------------------------------------------------------------------+
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
+-------------------------------------------------------------------+
|Filename: Program Timing Table.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=915|
+-------------------------------------------------------------------+