Sorry, I must have started that find-the-last-row post before you said you didn't need it.

Grouping: It happens I had to do that at a recent contract. It's obviously useful to automate, because when it's needed at all it's often needed with lot of data. Let's see, here... Ok, I found it. You use the Group method on whole rows, apparently. What you have to do is get your program to identify a clump of detail rows and Group those, and then identify a bunch of sub-phases (and their details) and Group those, and so on rolling up to the top. I had a number of levels in mine, up to five I think; you have only three, if you count the whole as one.

I simply must get some work done, so I'm going to leave you for now with just this: With the outline in your data cleared (or with another worksheet that isn't outlined) get your program to do something like this:What I think that will do is set up a bottom-level grouping for rows 5 through 9.

If that works, you can see that all you need to do is explain to your program how to find the proper rows for each grouping and do the same throughout your data. I'll come back tomorrow (maybe tomorrow) and we can work on how to do that. That part is a little more complicated than what you've done so far, but only a little.