match and update brands from comboboxes with columns based on selection combobox

[abdo meghari]

hello
I have many comboboxes linked with column A,B,C and many textboxes I fill the values and copy to specific month based on selected combobox "MONTH" so what I want when select from combobox the month then should copy the data from multiple comboboxes to col A,B,C and the textboxes it will copy to specific column contain the month based on selected combobox " month" and if I copy fill data again but they are already existed should just update the values or move to another month without repeat copying BRAND,TYPE,ORIGIN
thanks

[torachan]

The way you are using your comboboxes means you can enter a combination that does not exist in your sheet - what to do then ????
You need to make you second combobox only contain a selection list relevant to your first combobox choice.
Alternatively use a single listbox set to multichoice.
torachan.

[abdo meghari]

The way you are using your comboboxes means you can enter a combination that does not exist in your sheet - what to do then ????

.

then should copy a new data if there are no existed

[abdo meghari]

is there any help?

[torachan]

Patience brings it's own rewards.
Hope the attached does what you desire.
torachan.

[abdo meghari]

thanks not exactly there is a problem it copy repeatedly the brands should add the values to month in case there are matched comboboxes with columns A,B,C if not then copy to the bottom please check the file

[torachan]

Maybe this version is better.

[abdo meghari]

brilliant ! you're super great that's completely what I want
well done!!!

[torachan]

thanks for the feedback.
happy to oblige.
torachan.

[abdo meghari]

sorry come back in this old thread if it's possible mod the code . as you know I have to fill all of comboboxes( descripe ,type manfacture) together to fill if I don't fill all it will show 0 in sheet . I would make the code more dynamically to ignore others comboboxes which not filled .