Reproducing code to make fast when split data for each customer

Hello,
I enter data in sheet data for many customers .so what I want create summary for all customers and show the balance for each customer . when the cell c2 is empty should brings all data for all customers and if I select specific name then should show this customer and if I select another customer should copy to bottom without repeat the customer has existed , just updating I mean if add a new data in sheet data and it's existed in sheet report 1 it shouldn't copy to they bottom again , just change the data and the same thing should just copy the data remains values but if there are customers contain the balance is zero should ignore them in sheet report2
I put a simple expected result in report1 and some formulas how calculates but i don't show the formula in cells
so current code works with simple data , but when try with 15000-20000 row the excel will freeze and sometimes shows error !
any chance from experts to reproduce to make fast, please?

may not make significant difference to performance.

so should keep the original way .
I search for make it fast .

just copy random data as I did it.

No problem my end with performance.

what does mean that?

..... the macro runs FAST and with no errors!

which macro the original or your way?

how take time when test for file in post#3?

thanks for inform me John.

... so is the issue resolved ?

not yet
I'm still searching where is exactly the problem ......