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.
Bookmarks