Generating Report Based On Name & Month - Employee Calendar

**Gtrtim112** · 05-06-2013, 07:53 AM

I'm attempting to have a "Report" tab within my Employee Vacation Scheduler workbook. My goal is to have a tab in which I can generate a report or figures for any given employee and for any given month. I would then be able to print that "report" for the employee's file at the end of each month. I've attached a sample of what I think it should look like and have highlighted all the cells that would need to populate automatically based on the inputted information (Employee Name and Month). I'm hoping someone will know how to configure these formulas based on what I'm trying to accomplish.

Thanks!

**Lemice** · 05-06-2013, 04:10 PM

Hello,

Please see if the following attached file is what you are looking for.

Try to change the month on your dropbox, change the year on Year worksheet, and put in any code / employee name in Schedule worksheet, and notice the change.

Note that I also did a calculation on total "V" and "PD" hours, but I don't know how to calculate the "balance remain" so they are still number.