merge TOTAL row for each sheet based on selected name from combobox on userform

thanks.
how I get rid of empty in combobox1,please?

it's perfect
just I would add column E so should merge based on name in column C and just PAID word in column E for each sheet alone.
sorry about new requirement !
thanks again

it's awesome !
just I tested with more random data like 4000 rows for each sheet ,I note it delays some time to open the form.
is there way to make fast when open the form,please?
thanks gain.

Different method.

Please Login or Register  to view this content.

thanks jinon , but also should merge based on PAID word in column E , not only name in olumn C
I think the code will just merge based on name in column C !

Will any ONE sheet ALWAYS contain ALL names e.g BUYING [rather looping through all sheets]?

unfortunately in SALE sheet contains names are not existed in BUYING sheet.

Please post a file with large volumes so I can test any change.

just copy random data.

Is it changing one line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

?

thanks jindon again .
I think your way to calculating is not right as I did it

textbox5=textbox1-textbox2-textbox3+textbox4

Then perhaps

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

it's perfect !
I would add another condition if it's possible.
sometimes there is name is existed in in SALE sheet but not in BUYING sheet then will value in textbox2 will be minus value , so what I want the value in textbox2 should be positive value if textbox1="-"
thanks again

Negative value in TextBox2?

Impossible for the workbooks uplaoded.

If you upload a typical sample workbook that creates such issue, it might help.

In any situation, no textbox from 1 to 4 will have negative value, since the value in TOTAL rows are all positive.

Again, it will help if you upload a workbook with such data.

In any situation, no textbox from 1 to 4 will have negative value, since the value in TOTAL rows are all positive.

that's correct usually textbox1 will be bigger than values in others textboxes but if there is no value in txtbox1 then will be minus values in textbox5 example
textbox1=0
textbox2=1000
textbox3=100
textbox4=10
textbox5=0-1000-100+10=-1090
what I want if textbox1=0 then
textbox5=0+1000-100+100=1000

In any situation, no textbox from 1 to 4 will have negative value, since the value in TOTAL rows are all positive.

that doesn't make difference for you because I'm talking about calculation in textbox5 on userform

Do you mean

If TB1 - TB2 <0 then (Tb1 - Tb2) * -1 ?
Or just only when TB1 = 0 ?

Or just only when TB1 = 0 ?

yes this is what I meant.

try change ComboBox1_Change to

Please Login or Register  to view this content.

@daboho
not really how you calculate ?!
may you compar with OP,please?

try change ComboBox1_Change to

what about post#17?
it doesn't calculate correctly if the whole textboxes contains values!

forget about other codes, just follow #27.

@JT
this is strang ! , still slow to open the form, but I think this is not relating slowness with big data because I open the form not select name from combobox to do that yet !
anyway but the file shows errors calculation !!

@daboho
still shows error in calculation.
and shouldn't show empty in any textbox. should show zero as hyphen"-"

how about if textbox2.value = 0

should change calculation from

textobx1-textbox2-textbox3+textbox4

to
textobx1+textbox2-textbox3+textbox4

forget about other codes, just follow #27.

still shows error calculation!

The sum will be TextBox1+TextBox2-TextBox3+TextBox4 is correct ?

yes

f all textbox1 until textbox3 > 0 then
Result is -textbox1-textbox2-textbox3+Textbox4 is correct ?

no
should

Result is textbox1-textbox2-textbox3+Textbox4

You said

textobx1-textbox2-textbox3+textbox4 (when tb1 is not 0)
to
textobx1+textbox2-textbox3+textbox4 (when tb1 = 0)

When CR-1000 is selected
TB1 = 2,112.00
TB1 = 355.00
TB3 = 44.00
TB4 = 120.00
TB1(2,112.00) - TB2(355.00) - TBb3(44.00) + TB4(120.00) = TB5(1,833.00)

What's wrong?

What's wrong?

When CR-1000 is selected and based on PAID word
TB1=2,112.00
TB2=355+210=565
TB3=44
TB4=60+120=180
TB5=2,112.00-565.00-44.00+180.00=1,683.00

thanks JT for spotting my error
my apologies !
thank you for your time and you trying to give me better way to solve my requirements .

thanks jindon and sorry about my errors.
everything is ok .

@daboho
it's great , sorry about my error !
I wanted show hyphen instead on empty in any textbox.
any way thank you so much.