Modernizing Vacation Calendar At work. Multiple values returned from one table, to tab2

[Ceejtank]

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

[Pete_UK]

I would suggest a different approach to this. Have one sheet on which you could record the leave bookings made for each person in any order (i.e. date, person name and leave-type). Then have another sheet on which you could select the month and the year of interest (and possibly leave-type) and have the calendar generate itself automatically with the name of each person appearing on the appropriate day.

I have an example file that will do this for up to 12 names per day, and produce some statistics, although it will need some modification to suit your particular circumstances. Does this seem to fit the bill for you?

Pete

[Ceejtank]

I'm willing to look at anything thanks.

[Pete_UK]

Okay, the attached file illustrates what I described in outline earlier. You can record dates, names and leave type in the Leave_booker sheet. The entries can be in any order (you can see that I've added holidays after your sample data), but you must have a single entry for each date, as can be seen for Sharon's extra days. I've set up the formula in column A so that only entries with a "v" in the leave_type column will be displayed on the calendar, but other leave types will be counted in the stats table at the bottom of the calendar. The formula in column A is copied down to row 300, but you can copy this further if you wish.

In the calendar sheet itself you can select the month in K5 and the year in K6, and the calendar will automatically adjust itself and display up to 12 names per day for those entries in the leave_booker sheet that have a leave_type of "v". In addition, there is a summary sheet below the calendar which shows the stats for the currently selected month - these formulae look at data up to row 300, so if you have more you will need to adjust the ranges in the formula.

Hope this helps.

Pete

[SeanF64]

This is pretty good. What I want is slightly simpler.... I want to have a task column and a date column. And then on another tab, have a calendar that autofills the task content into the calendar, based on the date entered in the date column.

Example: Enter in January 1, 2014 as date and task is "Take out the garbage." I want "Take out the garbage" to show up on the calendar on the next sheet on the right day. What part of the code in this vacation sheet would do that?

[Pete_UK]

You shouldn't ask a question in someone else's thread - start your own instead.

In the meantime, here's an example from last month:

http://www.excelforum.com/excel-gene...-calendar.html

Hope this helps.

Pete