Extract data from one Worksheet to another
 

Dear All,

I have 2 worksheets. 1 is the destination sheet and the other 1 is the data
sheet where I want information from. I want to extract the following data
from the data sheet. These are the personnel id, employee name and cost
center account. What I want is if I fill in the personnel id number in a
particular cell, that the employee name and cost centre is also extracted in
to 2 seperate cells respectively.

The feature that wil help you is called VLOOKUP.

You've left out a lot of information about your workbook, but assuming the
following, maybe you can get the idea from this.......

Your Sheets are named Sheet 1 for destination sheet, and Sheet 2 for your
database.
On your database sheet, Employee ID are in column A, Names in column B and
CostCenter in column C.

Then, in cell b6 of your destination sheet, you enter the Employee ID number.
Then, in the cell where you want the Employee name to appear, put
=VLOOKUP(B6,Sheet2!A:C,2,false)

Then in the cell where you want the CostCenter to appear, put
=VLOOKUP(b6,Sheet2!A:C,3,false)

You can see, the formulas are exactly the same except for the number 2 being
changed to 3. This is the difference to lookup the Name, or the CostCenter,
either 2 or 3 columns to the right of the column with the Employee ID.

Modify the formulas as necessary to fit your application......

Vaya con Dios,
Chuck, CABGx3



"extract data fr. one worksheet to anothe" wrote:

Dear All,

I have 2 worksheets. 1 is the destination sheet and the other 1 is the data
sheet where I want information from. I want to extract the following data
from the data sheet. These are the personnel id, employee name and cost
center account. What I want is if I fill in the personnel id number in a
particular cell, that the employee name and cost centre is also extracted in
to 2 seperate cells respectively.