Hi, will try to explain my problem as best as I can.

I have 2 worksheets. Each worksheet has in column A a list of unique
customer numbers. Sheet 1 has 75000 rows AND 4 extra columns of data and
sheet 2 has 63000 rows. What I need to do in sheet 2 is:

If customer number in Sheet 2 has a corresponding customer number in sheet
1I need to insert the corresponding 4 cells of data aginst the customer
number in sheet 2

also remember the row numbers in sheet 1 & 2 do not correspond!

Please help :-)