I am working on a product configurator sheet.
All the items need for the final product are selected in column E. To select items I have created a filtered drop down menu base on tag in column D. My sheet as near 100 dropdowns menus and 83 filters tags. Some items are incompatible with other items. I need help to take care of incompatibilities in the items drop down menu, I don’t want to see incompatible items.
On sheet Optionlist, I create 6 more column to add incompatible items based on Item_Nb. If Item 3 is incompatible with item 5, in the item 5 row,column Incomp_1, I will input 3.
10% payment done [FONT="Calibri"]31L548694T657664L[/FONT]