Autofill from another workbook

[bowelch4]

Hi Everyone,

I am working on a project and would like to know if this is possible.

I have an excel file with every employee in my company. I am working on getting my own file where I could plug in the employee ID, and it fill only certain cells in that row. For example:

I have these fields that I would like to be autofilled by simply entering the employee ID

First Name	Last Name	Employee ID	Department	Sub Department	Job Title

The workbook I want to pull from has the below headers with data below:

ID

Legal Name in General Display Format

Legal Name - Last Name

Legal Name - First Name

Hire Date

Continuous Service Date

FTE

Employee Type

Active Status with Date

Time Type

Job Code

Is there a way that I can pick and choose which data I want to autofill from the master employee file?

You see, I don't need hire date, continuous service date, FTE, etc....and there are columns to the right, like Job Title that I want to pull into my working file.

Thanks! Feel free to point me to an article that may be out there already.

 

[bowelch4]

The column titles you see are just an example....there are about 55 columns in total on my master employee file.