Insert row

Hi again Cstolworthy,

Now with some data, I get an idea of what you are doing. I find text and values in Column G. This makes them sort funny and other bad stuff.

I've created a Pivot Table on a new sheet which may lead you to what you are ultimately after. I don't know what the other columns have to offer in your solution but do believe Pivot Tables may be where you are going. Try some of the power in Exce before trying to write (rewrite) code.

Find the attached with the start of a Pivot Table on the new sheet.