Vegs,

Have you tried using VLOOKUP? I think that would do the trick for you.

MG

Vegs wrote:
I'm working off of two worksheets.
Worksheet 1 contains all the data.
Worksheets 2 has partial data.
I need to use the data (in this case a part number) in cell A1 on worksheet
2 and find the same part number on worksheet 1 and copy the data in the
adjacent three cells on worksheet 1 to the cells adjacent to the part number
worksheet 2.

worksheet 1
A B C D
A100 x y z
A200 x
A300 y
A400
A500 x z

worksheet 2
A B C D
A300 y
A400
A500 x z