I need to be able to match a debit with an order number and have that debit removed, as you see below I have three columns, so if the debit matches the order number (see how (456.99) is the debit for order # 130923-1) I want to delete that debit (the whole line). Is there a formula/macro that I could use to accomlish this? I havre like 3000 records and it is time consuming to go through each line and delete each manually.
Cust Name Order # Balance
Verizon 130923-1 456.99
Linc Facility Services 130923-1 (456.99)
John Philip Sousa 131009-1 155.95
John Philip Sousa 131009-1 (155.95)
Yellowstone Natk 131289-1 11,172.60
Park Ridge Schist 131463-1 37.95
VA Medical CenFSC 131896-1 223.51
VA Medical Center 131896-1 (223.51)
Thanks for any advice.
Bookmarks