Hi,

I am trying to take our jumbled work calendar/tracker for vacation at work, and make it provide a nice monthly sheet that autopopulates the calendar based on the data provided.

I have attached the file. I have populated January 2 with some test vacation dates. It works by putting a "V" into vacation days, and then I would like the Tab "January" More specifically the cell(s) for january 2nd in this case, to populate with anyones name who has a "v" on the vacation tracker tab for that date.

Is this possible?

Thanks for looking!Vacation Calendar 2013.xls