Compare Amt between lines and move if matched

**NTB** · 10-28-2009, 04:13 PM

Hi all,

It's just a thought and I'm not sure if it's even possible.

Please see the sample I've attached.

I have a report that has thousands of lines... debits & credits. Most of them offset one another, 0 balance. However, there are still many w/ missing credits that need to be identied. Instead of going thru 10,000+ lines to pull out lines w/o credits - Is there a way that I can cross check the amount between lines (1&2, 2&3, 3&4 etc etc) and if their total is 0 then I want to move them to another sheet (Matched)?

Sorry if it's too confusing!

Thank you,

NTB

**Leith Ross** · 10-28-2009, 04:41 PM

Hello NTB,

What about these lines? Do they not match?

Please Login or Register  to view this content.

**NTB** · 10-28-2009, 10:09 PM

Yes... the it's the amount we're looking at... so those 2 lines will get cut over to 'Matched' since the sum between them is 0

**Leith Ross** · 10-28-2009, 10:40 PM

Hello NTB,

What would you do when there are multiple credits applied to the same transaction?

**Leith Ross** · 10-29-2009, 12:21 AM

Hello NTB,

That was fun. It works on the data you posted, but the real test is with the actual data. Run this on a copy of the original workbook to check the results. I added a button on the Data sheet to run the macro. Here is the macro code...

Please Login or Register  to view this content.

**NTB** · 10-29-2009, 06:08 AM

Just woke up and saw your response. I will test it at work, but you are truly amazing.
Thank you for spending time on this, and I will let you know the result w/i 2 hours.

NTB