Excel Coding

[schnabs]

I have some excel files I need to write some code for. This is a monthly process, so I'll need to do it frequently. This is how my data is setup.


ColumnA ColumnB ColumnC ColumnD
Balance
Row 1
Row 2 John
Row 3 400 11/27/08
Row 4 500 12/19/08
Row 5 0 12/30/08
Row 6 250 1/29/09
Row 7 300 2/1/09
Row 8 0 2/10/09
Row 9 225 2/15/09
Row 10 Total 225
Repeat

I have 90 files, with anywhere between 100-1000 customers in each, set up as such. Now as you can see, the sample I am showing has had a zero balance multiple times throughout the year. I only need the most current activity from his last zero balance. So all rows 3-8 need to be deleted. I still need the customer, and charges after their most recent zero balance. Thanks in advance.

 

[SkipVought]

ii36250 at

bellhelicopter dot

textron dot

com

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}