Get totals and remain for specific ID

[YasserKhalil]

Hello everyone
In my sample workbook I have two sheets .. Data sheet and the Expected Results sheet ..
In Data sheet I have clients that have specific totals (that should be paid) in column D .. and in column G the amounts that is paid ..
I need in the Expected Results sheet to prepare a report for those who didn't pay all the Total only .. as for who paid the total amount I didn't need to extract them ..
In other words if the value in column G is less than the value in column D then to deal with that row ..
For example :
The ID process 189 in second row of table has a total 90.000 and in column G there is a value 80.000 so he didn't pay all the total amount ..
and the same ID process pay another (second paid) in row 3 , he paid 5000 so the total is still unpaid completely
I have attached the expected results to illustrate the form of the report needed

Thanks advanced for help

[rcm]

Dear Yasser Khalil

Please try this macro.

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot for reply and for the code
As for results I don't need results if the Total amount is paid so as for ID Process 156 is not needed
Another point I noticed in results in column F the value 523 .. and in column M in cell M5 the value 0 .. what's this?

[rcm]

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much for this great code ..
I tested it on original data and it is ok but took some time
If there is a way to use arrays instead of loops I would be grateful
If your time doesn't allow , thanks a lot for great help you offered in this issue
Best Regards

[rcm]

Dear YasserKahlil:

You are mot welcome. Unfortunately, I have little to no expertise in arrays. I am very eager and hopeful to learn from another forum member how to use them in this case.