Display data as per combobox item selected
I had a excel sheet in which i have stored the raw material items, the suppliers of these items and the qc parameter details. I want to use the 2 comboboxes.
If suppose i select ABC item in 1st combobox, then in 2nd combobox only the suppliers of ABC item should be get displayed. Now when i select xyz supplier from 2/3 suppliers (in combo box 2) of ABC item , then the QC paramters of that item for that particular suppliers should be displayed in the respective cells.