populate balance on userform if existed in sheet and missed in another

[abdelfattah]

Your pictures shows nothing difference from my original code.

surely yes.
and I said

so you can keep all of cases in listbox1 as you writing is ok

and the speech is around listbox2 as I said.

but the problem will be in listbx2

what I want to be show new names in listbox2 and I explain you how listbox2 collect balances for names.
the listbox2 ignores names are existed in first sheet and not existed in second sheet
the listbox2 should show new names as marked in last picture

if you don't post a workbook showing exact desired results on worksheet(s)

of course I post what you want , but the result should show on form , not on worksheet, that's why I posted pictures especially last picture
if you insist last picture should show in worksheet then here is file as highlighted by red are new names.
again listbox 2 depends on listbox1 , but when there are names are existed in first sheet , not existed in second sheet the should brings from first sheet and show in listbox2

no way to understand

honestly I do my best.

so ask someone else.

I don't think so because this is yours and about month ago of post this subject nobody answers me.