maghari
01-18-2021, 10:34 AM
hi
I hope to find answering for my question , I would make rowsourses in combobox 1,2,3 from sh1,sh2,sh3,sh4 in the same columns b ,C,D without any duplicated , my idea depends searching from all sheets by the comboboxes because may some brands are existed in specific sheet , but not another for instance if the same brand is existed in sh1,sh2 then should not repeat in combobox 1 the same thing with rests combobox2,3 and sh3,4
note : I have a problem when I choose the batch from combobox1 should populate in combobox2, 3 but it only poulate in 2 this happens when I choose the the first and the second it from combobox1 , but if I choose another then every thing is ok I no know the reason from repeat the same item ,how can I fix it,please ?
if any body help I truly appreciate
I hope to find answering for my question , I would make rowsourses in combobox 1,2,3 from sh1,sh2,sh3,sh4 in the same columns b ,C,D without any duplicated , my idea depends searching from all sheets by the comboboxes because may some brands are existed in specific sheet , but not another for instance if the same brand is existed in sh1,sh2 then should not repeat in combobox 1 the same thing with rests combobox2,3 and sh3,4
note : I have a problem when I choose the batch from combobox1 should populate in combobox2, 3 but it only poulate in 2 this happens when I choose the the first and the second it from combobox1 , but if I choose another then every thing is ok I no know the reason from repeat the same item ,how can I fix it,please ?
if any body help I truly appreciate