Create a list according what i choose in A1!

Hi all.

I need your help on this.

In A1 of the first sheet i choose a customer. In column D of this sheet i need to see ALL the products that this customer works.

IN the priceList sheet i have in column A the Customers Names.

Starting from B1 and in the next columns i have my Product Names.

From b2 and down and for all the columns to the right i have the prices for eatch customer for eatch product.

If one customer does not use any product then the cell is blank.

I believe that looking in my example sheet everything will be clear for you.

Thanks in advance for any advice.

Thank you John and apologize for the delay in my reply.The difference of the hours!!

This works great in my example.

Unfortunately for me i am not able to modify your excellent code for my real workbook.

I need the validation list in B6. Not in A1 and i can not fix this.

Could you pls explain me which part of the code i have to modify for using the code?

Also can you explain a little the code so to be able to use it another time with different cell and different columns?

Thank you very mutch! Specially for your instructions. I'll study these!