How can I link one cell to a list of info in another workbook?
 

I have to workbooks, One workbook contains a list of personnel information
such as names and departments and the second has information regarding the
companies vehicle usage.

I wish to be able to link one cell/column in the second workbook to look
through the first workbook for the person's employee number and then place
his department into the cell.

If you need more clarification on this please email me at


Regards

Paul.

How can I link one cell to a list of info in another workbook?
 

Hi Paul

You talk about Names in one part and employee numbers in the other.
Assuming we are talking about Names in both cases, and, assuming on Sheet1
you have names in column A, and Departments in column B, with a header in
row 1 and data starting in row 2.
Further, assuming on Sheet2, row 1 is header, the person's name is in column
A and you want to put the result in column D

On Sheet2 in Cell D2
=VLOOKUP(A2,Sheet1!$A$2:$A$1000,2,0)
copy down column D as far as required.

This assumes up to 999 rows of data. Change ranges and cell locations to suit.
If this doesn't work, post back with more detail of what each sheet looks
like, where you want the data captured etc.


Regards

Roger Govier


PaulGrowns1 wrote:
I have to workbooks, One workbook contains a list of personnel information
such as names and departments and the second has information regarding the
companies vehicle usage.

I wish to be able to link one cell/column in the second workbook to look
through the first workbook for the person's employee number and then place
his department into the cell.

If you need more clarification on this please email me at


Regards

Paul.

How can I link one cell to a list of info in another workbook?
 

Roger thanks,

Sorry for any confusion. On worksheet one I have the following, Column a is
rank, column b is employee number column c is name and column d is dept.

On the second worksheet i have vehicle usage, so column a is the vehicle
reg, column b the miles travelled and column c is the drivers employee number

How can I link one cell to a list of info in another workbook?
 

Hi Paul

Try entering in D2 of Worksheet 2
=VLOOKUP(C2,[Filename.xls]Sheet1!$B$2:$D$1000,3,0)

Substitute your actual filename and sheet name.

Regards

Roger Govier


PaulGrowns1 wrote:
Roger thanks,

Sorry for any confusion. On worksheet one I have the following, Column a is
rank, column b is employee number column c is name and column d is dept.

On the second worksheet i have vehicle usage, so column a is the vehicle
reg, column b the miles travelled and column c is the drivers employee number
.

When i type in the employee number in column c on the second worksheet i
want the name and dept of the employer to appear in the next to columns
respectively.

The two worksheets are different files as the employee list changes from
week to week and it is not viable to have this info in one file on two
sheets. The sabve location for the files does not change.

Hope that this clarifies the situation a little better and you can offer me
a solution.

cheers

Paul

"Roger Govier" wrote:


Hi Paul

You talk about Names in one part and employee numbers in the other.
Assuming we are talking about Names in both cases, and, assuming on Sheet1
you have names in column A, and Departments in column B, with a header in
row 1 and data starting in row 2.
Further, assuming on Sheet2, row 1 is header, the person's name is in column
A and you want to put the result in column D

On Sheet2 in Cell D2
=VLOOKUP(A2,Sheet1!$A$2:$A$1000,2,0)
copy down column D as far as required.

This assumes up to 999 rows of data. Change ranges and cell locations to suit.
If this doesn't work, post back with more detail of what each sheet looks
like, where you want the data captured etc.


Regards

Roger Govier


PaulGrowns1 wrote:

I have to workbooks, One workbook contains a list of personnel information
such as names and departments and the second has information regarding the
companies vehicle usage.

I wish to be able to link one cell/column in the second workbook to look
through the first workbook for the person's employee number and then place
his department into the cell.

If you need more clarification on this please email me at


Regards

Paul.