Inserting new row(s) with subtotals based on multiple conditions

[mcmichaeljs]

I get a CSV file of varying length (# of rows) each month that contains a column for year (CCYY) and a non-adjacent column with either a greater than ">" or less than "<" value in it. After sorting the file by “>/<” within each year, I then need to start at the top row, and each time either the year value changes or the ">/<" value changes, I need to insert a row that counts and/or subtotals the values in several other columns based on the x number of non-blank rows above it where "x" is the number of rows since either the year or the">/<" value has changed. If the change is in the year value, I then also need to insert another blank row below the newly inserted subtotal row. I've tried doing this in two steps (first inserting a row every time the ">/<" changes and then inserting a row when the year changes, but with only partial success. It seems that this shouldn't be too difficult to do in VBA, but I haven't be able to get it. Any help is much appreciated.<o></o>