split data from sheet to three sheets for many names based on two columns

hi experts
I have sheet contains data in sheet1 what i want split data to many tables in sheets (validation, not validation , all)
based on column a , c so any names contain validation or not validation it copy to the sheets names validation ,not validation , as for sheet all then merge validation and not validation with take a notice in column g there is formula for every name contains the first row and the second row are different so i put the formula to see how should work and i put expected result in the sheets (validation, not validation , all)
thanks

Please Login or Register  to view this content.

thanks for this awesome code but there is still problem about formula should first balance + debit -credit i highlight the wrong values by red color maybe my explanation is not clear I put some explanation in attached file and I would show total each customer and the end of last row show all total for all customers in all sheets please check it if is not clear please inform me what you want to know
thanks for assistance

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

fantastic !! the formula now has been fixed just remain one thing about the total debit & credit , balance
if you have time please check it

Please Login or Register  to view this content.

great ! you seem to you don't see the total all of customers in sheet all sheets
after show total each customer it supposes showing the total all of customers in all sheets in last row, may you check it please?
thanks again

Insert lines in

Please Login or Register  to view this content.

Please Login or Register  to view this content.

well done !! many thanks for your help