Hi there!
First time post here.
I am trying to find a solution to my problem.
Currently I have Sheet 1 with names running down Column A and Dates running over Row 1, Much like a calendar type thing (date running consecutively across the rows)
On the Sheet 2 I have Name on Column A, Date Start on Column B and Date Finish on Column C.
I am trying to come up with a code that, when I add the dates (Start and Finish) next to the names in Column A on Sheet 2, it colours in the cells in Sheet 1 with the dates from Sheet 2.
The intent is so that when the dates for Sheet 2 are entered next to the Name John (E.g. 1/1/10 - 3/1/10), Sheet 1 has the 1/1/10, 2/1/10 and 3/1/10 colored and 'blocked' off so to speak, next to John's name.
Please find the attached images as references to the problem...
Any help that anyone could give would be greatly appreciated
Cheers!
Bookmarks