Hi-

I have a macro already written which manipulates a worksheet, but
need to update each cell in sheet1(coulumn 1) based on informartion o
3rd colum cell. I have written all the data in sheet 2 of th
worksheet. I need to do a comparison with worsheet 1 cell (column 3) t
worksheet 2 and find the matching value and update cell of column one.

FOr example:

sheet 1 for worksheet has:

12 JOHN
13 SMITH
13 KEERY

Sheet 2 of same Worsheet has

ANALYST JOHN
DENTIST SMITH
OFFICER KEERY

I need to match column 2 of sheet 1 to column 2 for sheet 2 and updat
column1 of sheet one.

The OUTPUT SHOULD BE in sheet 1:

ANALYST JOHN
DENTIST SMITH
OFFICER KEERY


I would extremly appreciate if someone could help me with this t
update my macro to do so.....HELP!!!

Thank You
Neelim

--
Message posted from http://www.ExcelForum.com