Change of event using 2 combobox
I had 2 excel sheets. In one sheet i had some details. For example, In Column A, S.Nos, in Column B, Vendor name, in Column C Item names, in Column D,E,F,G its QC parameters.
Now in second sheet, I want to use a standard format, in which i will use 2 comboboxes for Item name & Vendor Name.
For eg cb1 is combobox for Item Name & cb2 is combobox for Vendor Name.
When i select a item in cb1 , the related vendor should get selected in cb2. and the QC parameters should be displayed with respect to the 2 combobox value combinations
Please help me out at earliest.