Hi Dawn,
If I understand the problem correctly (you have only
employee name info on both sheets), could you do this
(requires that the employee names be identical in both
sheets and there be no duplicates)?:
Sort the sheet that has the data you want alphabetically
by employee name and use it as a lookup table for the new
sheet. In the target cells of the eval sheet, type in
lookup formulas based on the employee name. If this
works, then go back and replace the lookup formulas with
hard values (Copy/PasteSpecial/Values).
If there are duplicate employee names (say, names are
split between first and last names, and there are
duplicate last names), then you'll have to use
concatentation to create a unique employee name
(lastname&firstname) and do your sorting and looking up
based on the concatenated values.
Please post back with how it goes.
-----Original Message-----
This is probably simple but I can't figure it out. I am
trying to create employee evalutaion workbook that will
take employee names, social security numbers and
employment anniversary dates from one worksheet that is
already created and merge them into the correct cells on
the Employee Evaluation worksheet that is also already
created so I don't have to type each employee's
information onto the evaluation. Also this will help when
we lose or gain employees I can just remove or add them
from one worksheet. Please help!
