Hi there,

I had a similar problem recently and I got around it by
using arrays, but this may no be applicable in your
circumstance.

I need a bit more information to provide you with help on
the best solution, is the information in the rows
basically reoccuring, ie could you make a listing of all
the possible data and put that in an array to take care
of, as this would be programmatically the best way.
Otherwise you will need to do a sort on the information so
that all like data is together, then you will need to do a
series of If and While clauses to consolidate the
information.

Let me know and I will try to help as I have already got
solutions for both of these ways in test spreadsheets.

Yours sincerely,

Brent McIntyre