VBA to split accurate similar value from debit and credit range

[johnmacpro]

Dear experts

I have list of two range debit and credit along with barcode which have similar value on both side i want split the barcode which has no opposit value of plus and minus

for e.g Indebit BD01-100010-MAX-45125 ,70,503.76 Incredit BD01-100010-MAX-45125 (70,503.76) adjust to zero which not adjust to zero those row barcode and values move to sheet DoubtA/C.



please find the attachment

[johnmacpro]

Any experts help on this?

[LeoTaxi]

Some kind of start

Please Login or Register  to view this content.

Kind regards
Leo

[johnmacpro]

Thanks for the Code sir, I have small requirement which is on sheet DoubtAC should have line of debit and credit which is not opposition balance

for e.g BD02-101010-YMR-56875 3,978.80 same value not in credit side so this line copy DoubtAC
BR01-100010-MTM-45125 (7,845,245.00) same value not in dedit side so this line copy to DoubtAC

Rest of all matching both side net to zero lines value should copy to BillingAC Sheet.

for your reference:
Data is like 48 line in debit 49 line in credit. Debit 5 lines move to DoubtAC, Credit 6 lines move to DoubtAC, rest of netzero 43 lines move to BillingAC.

please find the attachment. Thanks sir for being spend valuable time for me..

[johnmacpro]

experts Please Help on this