Vacation workbook
 

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.

Vacation workbook
 

On 11 Iun, 17:04, Carolina Girl
wrote:
Any help would be greatly appreciated. I am trying to write a code that will

Hi
If you agree , you can send your wbook to e-mail adress
with more informations .

BR