sethu29
06-21-2020, 04:20 AM
Hi Support,
I've two Sheets. Sheet one (Employee Details) with Date as Header. I'm using this as calendar.... I would like to bring the Leave Type from Data Sheet to Employee Details Sheet.
1) Criteria 1- Only Approved Request (Status)
2) Criteria 2- Name match with Employee Name for the particular Date available in Employee Details Sheet
3)Criteria 3 - Within Start Date and End Date
Example Output below
Date
6/1/2020
6/2/2020
6/3/2020
Employee1
PL
CL
CL
Employee2
CL
CL
CL
Employee3
CL
CL
CL
Please help as this is very urgent
If no Leave , then leave it blank
Thank you
Sethu
I've two Sheets. Sheet one (Employee Details) with Date as Header. I'm using this as calendar.... I would like to bring the Leave Type from Data Sheet to Employee Details Sheet.
1) Criteria 1- Only Approved Request (Status)
2) Criteria 2- Name match with Employee Name for the particular Date available in Employee Details Sheet
3)Criteria 3 - Within Start Date and End Date
Example Output below
Date
6/1/2020
6/2/2020
6/3/2020
Employee1
PL
CL
CL
Employee2
CL
CL
CL
Employee3
CL
CL
CL
Please help as this is very urgent
If no Leave , then leave it blank
Thank you
Sethu