Is it possible to create a macro to group?

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,

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.



Mike Piazza wrote:
>
> 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