Neall wrote:
OK it might be easier to explain

I have sheet 1 which I have pulled all the customer data I need

On sheet 2 I have created a "display" section where you enter a customer
number or use the drop menu to select the customer number (A6)

When A6 has a customer number in it I then need to display the following
information about that customer pulled from sheet1 (data sheet) onto sheet 2

Part numbers the customer has separately (in A13,14,15,16 etc) the
description of the part numbers (in B13,14,15,16 etc) and the quantity (in
C13,14,15,16 etc)

Hope that helps





Might be easier yet if I could see the actual workbook. If possible, post a
copy of it to www.savefile.com and I'll take a look.