Bank Reconciliation with VBA

Xl genius I need your help!!!!!!
I have the attached xl file and I would like to make a reconciliation through all this transactions.
I would like to compare first, all “N” the “REF” column. If the find the same (one or more times) I would like to check the “M” column and make the total sum (of this reference) in order to “much” and make zero total.
As an example [ATTACH]378738
-10 REF2525
9 REF 2525
1 REF 2525
I want all the above transactions to exclude or to highlight this transactions.
After all this I would like to have all this transactions without munching in ref column and without the total sum of this sums zero

Thank a lot in advanced

deleted....

@protonLeah

I attempted to PM you on this Thread Title but it told me

protonLeah has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

I'd suggest MANY of us know pretty much what the OP is looking for by just looking at the Title. Sure, perhaps it's not as expansive as it should be...perhaps it should have said

Bank Reconciliation with VBA

but that title would not have told us anything more significant.

I think, should I wish to spend time on this Thread (it's not easy), I may choose to not honor this admonishment

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Sorry...

i m sorry to bridge the rule 1

google:

About 50,500,000 results
Showing results for Reconciliation

i dont want to "play" with words like ie, matching columns : 62.100.000...
i prefered in order to do all this conversation regarding "rules" to give me the right path/suggaestion if you wish to help me ...
As my friend above suggested a new title, i ll change it to be harmonized with the forum rules...

thanks a lot once again

Hi chrism_cfu

I've not forgotten about you. I'm looking at it.

Please explain this a bit further...to what are you referring?

i dont want to "play" with words like ie, matching columns : 62.100.000...

Hi chrism_cfu

Place both of these workbooks in the SAME Folder

Open the Code Book, Click the Button. You'll be prompted to select your Import File. The Code will do the rest.

Hi chrism_cfu

Let me look at it for a bit...

Hi chrism_cfu

As before, place both of these workbooks in the SAME Folder

Open the Code Book, Click the Button. You'll be prompted to select your Import File. The Code will do the rest.

Please check the results CAREFULLY...only you know what they SHOULD be.

The Code takes about 30 seconds to run on my Platform...be patient.

Hi chrism_cfu

You're welcome...hope testing goes well...let me know.

This most likely will not happen...I'm not a Traveler but I appreciate the offer.

the more i can do for you is a free guiding tour when you visit Greece

Hi chrism_cfu

To revert to the Original Code, in Code Book, in Sub Reconcile(), comment out the Line of Code as indicated..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

sorry i cant follow
maybe my bad english didnt help ...
as a recap i would like to say that i didnt want the vba to close the enrollments that had different currency different amount but the same reference. i want to closed only the enrollments with same reference and the tolal amount was zero. as the first vba that you create.
my worries are that when i "run" the macro they closed also the yellow enrollments (see attached file im my previews post) that the dont have the criteria that i mention previously. could you please check why they closed this enrollments? (i make the changes that you said above but still the yellow enrollments disappear)

thanks a lot

Hi chrism_cfu

The attached File is the same File as is attached to Post #9.

Hi chrism_cfu

Attached is the Output I get as a result of running the Code. Am I missing something>

You're welcome...glad I could help. Thanks for the Rep.

Hi Chris

Please attach the Code Book you're currently using.

Hi Chris

It'll take me a bit to work out the logic...won't be tonight. It may help if you posted your raw 2.3.xlsx File before ANY Code has been applied.

Hi Chris

Try the revised Code in Code Book attached.

Hi Chris

Please attach a jpg image...I'm unable to view png images.

Hi Chris

Yes, I can see it now. Was the Code run on the Sample File (2.3.slsx) or a different File?

I have to pick up my Grandson at the Buss stop in a few minutes so I'll need to get back to you later.

Hi Chris

You'll get that error if no records are found.

Add the Lines of Code as indicated

Please Login or Register  to view this content.

You're welcome...glad I could help.

If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

Hi Dan

Have you started a Thread for your issue (Forum Rules)? Please post a Link to this Thread in your new Thread.
If you wish, PM to me a Link to your new Thread...I'll be happy to look at it with you.