Is it possible to create a macro to group?

[Guest]

I am trying to create a macro that will reference specific cells and then
depending on the result of those cells will "group & outline" several other
rows?

Is this possible?

Thanks,

 

[Dave Peterson]

Try recording a macro when you do it once manually to see if that helps.

But I think I'd try to use excel's built in Data|Subtotals.

If your data that should be grouped isn't the same (but still needs to be
grouped), then you'll have to do some more work.

I'd insert a helper column and somehow give each group its own unique
indicator. Then Data|subtotal will work nicely.