C
Carolina Girl
Any help would be greatly appreciated. I am trying to write a code that will
take information from one worksheet and highlight a calendar on another
worksheet (same workbook) i.e.
Worksheet 1 (Vacation)
A B C
1 name start date back date
2 GH 5/5/08 5/18/08
3 JB 5/15/08 5/19/08
Worksheet 2 (Calendar) One day in each cell
May
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27
I need May 5th to May 18th highlighted (yellow will work) and GH in each
cell and May 15th to May 19th highlighted and JB in the cell. Can this be
done? Overlapping may happen but so the same color will be fine as long as
the name is inserted.
take information from one worksheet and highlight a calendar on another
worksheet (same workbook) i.e.
Worksheet 1 (Vacation)
A B C
1 name start date back date
2 GH 5/5/08 5/18/08
3 JB 5/15/08 5/19/08
Worksheet 2 (Calendar) One day in each cell
May
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27
I need May 5th to May 18th highlighted (yellow will work) and GH in each
cell and May 15th to May 19th highlighted and JB in the cell. Can this be
done? Overlapping may happen but so the same color will be fine as long as
the name is inserted.