Use resource name highlight the Start End Date in corresponding month sheet

[dhiraj277]

Hi Chandoo,


I am new to excel and have just started learning the various useful features Excel offers.

I am trying to create an Excel Leave Tracker which picks up the Resource Name, Start Date and End Date from "Master Sheet" and depending on the dates(month) opens the corresponding month tab(sheet) and highlights the calendar dates.


Ex: Master Sheet Data:


Resource Name Start Date End Date

Dhiraj 1st March, 2013 5th March,2013


Expected :When I hit the macro button then "March" tab(sheet) should open and dates from 1st March till 5th March, 2013 should be highlighted in some color.


Can anyone help me in achieving the desired result or guide me in right direction.


Note : How Do I attach an sample excel for your reference.


Thank You In Advance

Dhiraj

 

[Hui]

Dhiraj


Firstly, Welcome to the Chandoo.org Forums


I'd suggest you start by reading the 3 Green Sticky posts at the top of: http://chandoo.org/forums/


Secondly, I'll suggest that you think of a Data Source and a Report

So that when you select a person/Date the report will generate a Monthly Report in the Month you want and highlight the Person/dates as appropriate