3 dropdown list, update on each other respectively...

Hi all

I’m newbie to works with excel programming and macros, I hope anybody will help on this…

I’ve created three named range to be used in three dropdown lists respectively from Data Validation menu

Named range 1: Company_A_PartNumber
Named range 2: Company_B_PartNumber
Named range 3: Product_Description

When I choose the Company_A_PartNumber from dropdown list, Company_B_PartNumber will shown the correct part number, and Product_Description also display the corresponding description.

Similar to other two dropdown lists (Company_B_PartNumber and Product_Description), e.g. when I choose part number from Company_B_PartNumber, the correct data will automatically shown in Company_A_PartNumber and Product_Description dropdown lists.

Hope I’m clearly express the situation.

I’m using excel 2007, Thank you for your help!

regards,
kimyap