Removing bad payments from report
Removing bad payments from report
(OP)
Hi , i have payments in report that went nsf and i would like to remove those 2 rows. For example
The red are the rows i want removed using vba code
Thanks
CODE -->
A B C
Date Type Amount
1/31/2008 PA 487.00-
2/29/2008 PA 487.00-
3/31/2008 PA 487.00-
3/31/2008 NF 487.00
5/12/2008 CS 974.00-
5/31/2008 PA 487.00-
6/30/2008 PA 487.00-
The red are the rows i want removed using vba code
Thanks
RE: Removing bad payments from report
I could derive what I think is the logic based on your example, but it would be much more desirable if you were to explicitly state the logic clearly, concisely and completely.
RE: Removing bad payments from report
Column A starting at A5 has the Value date (cust payment date), in column B starting at B5 is the payment type meaning cash or pre-auth etc...and in column C starting at C5 is the amount cust paid. Sometimes when a payment is made that payment goes nsf. These are the rows i want removed.
CODE -->
so i want the rows in red removed because those are bad payments
RE: Removing bad payments from report
CODE -->
RE: Removing bad payments from report
RE: Removing bad payments from report
Think it through again and make a clear, concise and complete logic statement.
RE: Removing bad payments from report
If in column C there is a character "-" and one cell below has no character "-" then delete those 2 rows
RE: Removing bad payments from report
BTW, this is a forum707: VBA Visual Basic for Applications (Microsoft) question.
So the first thing that you ought to have done is to change the TEXT on the amount column, that you could not possibly use in ang arithmetic operation, to NUMBERS.
You might use a formula like this...
=IF(RIGHT(C5,1)="-",-1,1)*LEFT(C5,LEN(C5)-1)
RE: Removing bad payments from report
RE: Removing bad payments from report
RE: Removing bad payments from report
RE: Removing bad payments from report
Fat fingers on my iPhone!