• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To Retrieve data of an employee from a master data

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...
 
Provide us with a sample worksheet (antonymous) information. 8-10 records only needed. Mock up what you want the solution to look like also. No pictures please.
 
I am enclosing the sheet of master data and the out put sheet which i want. So please look into it and provide us solution.
 

Attachments

  • Sample data.xlsx
    22.2 KB · Views: 2
sairam_pariti
Your ... or code
Note
# Output required-sheet's cell B2 gotta be green to see expected results
( Selecting cell B2 can control color of cell. )

Usage
# Select any valid row from Master Data-sheet to see expected results (if as written in Note)
 

Attachments

  • Sample data.xlsb
    31 KB · Views: 8
Back
Top