Delete Void Invoices

D

Donna

Some invoices only have 2 lines when they are void but some have several
lines. How would I set up a formula to remove all of the lines except the
one that says receipt when the invoice if void?
2650741 $1,484,822.62 Inv $1,484,822.62
2650741 -$222,724.00 Receipt -$222,724.00
2650741F -$1,262,098.62 Finance -$1,262,098.62
2650741 -$1,484,822.62 Void -$1,484,822.62
2650741F -$1,262,098.62 Finance $1,262,098.62
2650741 $222,724.00 adj $222,724.00
Donna
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep lines when one column equals certain criteria 2
formula to disperse data to several worksheets 3
VBA works in orignal but fails in copy of database 1
import office accounting 0
Look Up Formula With Veried Search Range 2
Button to duplicate current forms (for an invoice) 1
VLookup sum multiple matches 1
If over 60, then show all detail 1

Top