sairam_pariti
New Member
Dear All
Please provide a solution for my task. I am having an master sheet containing all the employees details such as employee ID Name, Designation, Date of Joining, Date of Leaving and the man days worked monthly.
I want to retrieve a particular employee data by entering his employee id. If i enter employee id only the employee corresponding to the id details must come as below:
Name:
Designation:
Date of Joining:
Date of Leaving:
Month Mandays
for Ex: jan23 24
feb 23 22
so on. from the date of joining month and date of leaving month. So please provide solution by writing formulas or code.
Very much appreciated if it is solved.
Sai...
Please provide a solution for my task. I am having an master sheet containing all the employees details such as employee ID Name, Designation, Date of Joining, Date of Leaving and the man days worked monthly.
I want to retrieve a particular employee data by entering his employee id. If i enter employee id only the employee corresponding to the id details must come as below:
Name:
Designation:
Date of Joining:
Date of Leaving:
Month Mandays
for Ex: jan23 24
feb 23 22
so on. from the date of joining month and date of leaving month. So please provide solution by writing formulas or code.
Very much appreciated if it is solved.
Sai...