+ Reply to Thread
Results 1 to 1 of 1

Can't remove debits/credits that match

  1. #1
    Registered User
    Join Date
    03-08-2005
    Location
    NEW YORK, USA
    MS-Off Ver
    2019
    Posts
    9

    Can't remove debits/credits that match

    Hi I need a formula or macro to accomplish what I describe on the attached doc. Thanks


    Order # Cust Name Balance PAID BAL 05/31/10
    135318-1 Kalwall Corporation 561.06 - 561.06
    136353-1 Abbott UFSD 66.45 - 66.45
    136710-1 Acalanes Union HS Dist 434.95 - 434.95
    135931-1 Addison Post Office 56.15 - 56.15
    135931-1 Addison Post Office - 56.15 (56.15)
    135322-1 Adjo Contracting 378.00 - 378.00
    135322-1 Adjo Contracting - 378.00 (378.00)
    135594-1 Adjo Contracting 24.50 - 24.50
    135594-1 Adjo Contracting - 24.50 (24.50)
    136802-1 Adjo Contracting 186.00 - 186.00
    136082-1 AE Manning Inc. 333.85 - 333.85
    136082-1 AE Manning Inc. - 333.85 (333.85)
    137000-1 AE Manning Inc. 64.35 - 64.35
    137000-1 AE Manning Inc. - 64.35 (64.35)


    I need to do a formula or macro that will do the following: I want to delete all the customers that have a 0 balance. If you look at the above everything highlighted would be a 0 balance since the balance and paid amount match for the specific order number. So order number 135931-1 has a balance of 66.15 and a paid of 56.15 so instead of printing our a positive and a negative in the balance column I just want it to either put a 0 in for both or ideally delete the matching transactions.

    Is there a formula or macro that will accomplish this, I have over 2000 records to go through and it is just too time consuming. Thanks for any ideas.
    Attached Files Attached Files
    Last edited by pike; 06-12-2010 at 06:27 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1