Vacation workbook

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.
 
Y

ytayta555

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
(e-mail address removed) with more informations .

BR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top