Trying to get vacation tracking spreadsheet to automatically populate calendar

I have an employee absence tracking spreadsheet that I would like for it to make an automatic entry onto an excell calendar, whenever an entry is made for that date, but it must also be able to make that entry for a max of 3 employees out of 14. (say employee 1 takes off vacation on January 6, 7, 8, 9 & 10) it would populate my excell calendar for those dates, with employee 1's name. The tracking sheet also tracks sick leave and roving holidays, but it only needs to tell me on the calendar who is off, not what type of day they are taking off. I really want to stay with the calendar format, and not a chart or dashboard view. I have attached what I have, and would appreciate any help.Example.xlsx

Take a look at this thread:

http://www.excelforum.com/excel-form...e-to-tab2.html

it might give you some ideas.

Hope this helps.

Pete

Thanks Pete!, it did give me an idea and it solved my problem. Since I wanted my calendar to populate a name when an entry was made on the tracking sheet(vacation, sick leave, or roving holiday), I designed my calendar with 14 cells for each date, 1 cell for each employee, and I used the following formula for each cell: =if(sum(January!C7,January!C8,January!C9>0),"employee 1"," ") any entry into any one of the cell groups would render a true condition and would populate the calendar with their name, no entry on the tracking chart and the calendar cell would remain blank. It did get rather teadious building the calendar. Thanks Again.

Glad I was able to set you on your way.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete