I have a workbook with two worksheets.
One one sheet a part number will be scaned and entered into col A.
The other worksheet will have a existing list, in col A the part numbers and
col B thru F will have other information that goes with the part number.

When the user enters the part number ( using a scanner) it will appear in
col A of the first worksheet, I want the other information ( in worksheet 2 )
matching that part number to appear in col B thru F in worksheet 1.

How do I make col A search for the row with the same part number in
worksheet 2 and bring the data over to worksheet 1 in col B thru F?
Thanks,
Barbara