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.