match among multiple combo boxes and multiple columns and update the values

[Alaa mg]

hi

I have data in sheet1 and comboboxes (1 to 15) and textboxes (1 to 25) so when select items from comboxes and if I write the values in texboxes contain labels QTY1,2,3,4 then should match with the columns B,C,D and should overwrite the already values are existed and summing and the formula in textbox NET should be like this QTY1-QTY2-QTY3+QTY4 and copy all of the values to COL E,F,G,H,I

original data

the expected result

 

[Alaa mg]

any experts do that ?

 

[Akuini]

@Alaa mg
Could you upload a sample workbook (without sensitive data) to a free site such as dropbox.com or google drive & then share the link here?

 

[Alaa mg]

Hi
this is my file, if my explanation not clear please tell me what you want to know
CC.xlsm

 

[Akuini]

@Alaa mg
I've downloaded the file.
1. You populate the code via Rowsource, but the formula of the named range is like this; =#REF!#REF!
so I can't get the combobox to work.
2. In Private Sub Workbook_Open, the code refer to a directory/files that I don't have so I deleted the Sub.
3. How many rows is your original data? hundreds? thousands?
4. Could you explain in more detail the data entry process? First you choose items via combobox then what?
5. Is it possible you choose combination of items that doesn't match data in the sheet? For example: BT-SW-1000 CC-OO-1000 IT

 

[Alaa mg]

about the point 3 my data at least 4000 rows

about 4 when select combo box it should populate the values in textbox if there are existed and if I change the value then should overwriting it and summing for instance if populate in textbox value 5 and I rewrite value in the same textbox is 2 then when update the value in sheet should be 7 and if there is empty cell and add value then should add to it

items that doesn't match data in the sheet? For example: BT-SW-1000 CC-OO-1000 IT

then should show message " this is item is not available, do you want entering this item" if I press yes then should add all of data from multiple textboxes and comboboxed to sheet and if I press no then nothing happens

finally about rowsource if you have code to make dynamically in multiple comboboxes without duplicated and empty it will be a great

 

[Akuini]

Ok, I understand the requirement.
I'll try to write the code tomorrow.

 

[Akuini]

Try this:

1. I put formula in col I: =E2-F2-G2+H2
2. You need a helper column (col M), you may change it in this line:
Set c = .Range("M1").Resize(n - 1, 1) 'helper column

3. You may change the sheet's name in this line:
Private Const Shn As String = "Sheet1"

4. After filling data in the combobox & textbox, hit the command button.

the workbook:

Alaa mg 1

 

[Alaa mg]

firs thanks for your help

second I'm asking about helper column (col M) is it necessary use it ? is not way just do that like the others columns B,C without use helper column ?

third when I press repeatedly the button of course it will change the values continuously may be press unintentionally then the values become wrong , so to overcome this problem I would show message and issue sound of warning message "you entered already the values, do you want continuing" if press ok then continue calculating if press no nothing happens

fourth when add a new data should increment the numbers in COL A(ITEM) .