Transfer PTO type from Sheet2 to Sheet1 under Specific date

[ahc273]

Hi,

I am trying to track PTO for my employees in excel. what i did is in Sheet1 named "Overview" i have put it dates in Row 10 for the whole month. In Sheet2 named "John", i have put in start and end date for every PTO taken and the type of PTO in column D for that date range.

Now what i would like to do with this data in column D in Sheet2 is to be transferred under a specific date in Sheet1. for example if the type of PTO taken by John on 5/1/15 thru 5/5/15 was a Sick leave, then i would like the word "Sick" to be transferred automatically to Sheet1 under the dates 5/1/15 through 5/5/15.

can someone help me please?

thanks.

[ahc273]

Can someone plz help...?

Hi,

I am trying to track PTO for my employees in excel. what i did is in Sheet1 named "Overview" i have put it dates in Row 10 for the whole month. In Sheet2 named "John", i have put in start and end date for every PTO taken and the type of PTO in column D for that date range.

Now what i would like to do with this data in column D in Sheet2 is to be transferred under a specific date in Sheet1. for example if the type of PTO taken by John on 5/1/15 thru 5/5/15 was a Sick leave, then i would like the word "Sick" to be transferred automatically to Sheet1 under the dates 5/1/15 through 5/5/15.

can someone help me please?

thanks.