Leave Planner

edward91

New Member
Joined
Jun 29, 2010
Messages
24
i have a pretty tricky senenario here..i have a data dump of employee leave.Containing the name, number of consume day,start day and end date.
i trying to map the them into a "planner"which i cope from internet..
is there any method like vlookup,advance filter,match or index to help me solve?


this is a sample of my raw data
94934839.jpg


something like if the start date of the employee = the calendar date it will display the LIST of employee whose start date is on tat day..does not need to be a lot just enough to fill up the space in the calendar l
this is how i want it to be
78590448.jpg



whereby the 2 mean e day consume and apple mean name of the employee

http://www.vertex42.com/ExcelTemplates/excel-calendar-template.html
this is e link whr i dl the calendar template frm
 
Last edited:

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

shemayisroel

Well-known Member
Joined
Sep 11, 2008
Messages
1,867
Could you please post up an example of how you would want you result to look like - base the resulst off your sample data and perhaps try & exaplain how you came up with them
 

edward91

New Member
Joined
Jun 29, 2010
Messages
24
93625364.jpg
37755165.jpg



is this more clear? if u dun mind..i can arrange to meet up with u.i pretty despo now > <
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,837
Messages
5,833,918
Members
430,244
Latest member
Ireland1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top