Hey Guys
I am trying to remove the below row if the condition exists where a payment was issued and then cancelled. The cancelled payment will show a "off" in the type and the negative number.
AMOUNT TRANSACTION ISSUED START END
1973.38 Loss 4/27/2011 4/14/2011 4/27/2011
-1973.38 Loss Off 4/27/2011 4/14/2011 4/27/2011
Sometimes we will reissue the check and I will then have a + - then + again. I would like to keep the one with the most recent issue date and wipe the others away
1973.38 Loss 1/21/2012 1/9/2012 1/22/2012
-1973.38 Loss Off 1/21/2012 1/9/2012 1/22/2012
1973.38 Loss 2/3/2012 1/23/2012 2/5/2012
What this is stopping me from doing is getting an accurate total of the days between start and end dates as my calculation in VBA does the subtraction based on Cells(r, 10) = (Cells(r, 8) - Cells(r, 7)) + 1
Anythoughts?
I am trying to remove the below row if the condition exists where a payment was issued and then cancelled. The cancelled payment will show a "off" in the type and the negative number.
AMOUNT TRANSACTION ISSUED START END
1973.38 Loss 4/27/2011 4/14/2011 4/27/2011
-1973.38 Loss Off 4/27/2011 4/14/2011 4/27/2011
Sometimes we will reissue the check and I will then have a + - then + again. I would like to keep the one with the most recent issue date and wipe the others away
1973.38 Loss 1/21/2012 1/9/2012 1/22/2012
-1973.38 Loss Off 1/21/2012 1/9/2012 1/22/2012
1973.38 Loss 2/3/2012 1/23/2012 2/5/2012
What this is stopping me from doing is getting an accurate total of the days between start and end dates as my calculation in VBA does the subtraction based on Cells(r, 10) = (Cells(r, 8) - Cells(r, 7)) + 1
Anythoughts?
Last edited:
