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.



Yogesh

__________________
Yogesh