Macro to "Auto Outline" (Group)

[excelpuppy]

Hi,

I am looking for macro that will help me Auto Outline the rows in my spreadsheet.

Here is a sample of the data I am working with: Assume the data starts in Cell A2.

001-Ladanian Tomlinson
002-Mark Sanchez
New York Jets
010-Michael Vick
011-Desean Jackson
012-Brad Celek
Philadelphia Eagles

Basically I would want a macro that "reads" down and reads and groups all the data for a team once it hits the alphabetic "team" name. My thinking is that if you can somehow read the first three characters and if it is a numeric value then includes those rows to outline until it hits a three character (alpha) combination.

I hope this makes sense and is easy to do. It will really save me a ton of time.

Thanks.

[Richard Buttrey]

Hi,

Assuming every row which has a "-" as the fourth character is to be grouped then try:

Please Login or Register  to view this content.

[excelpuppy]

Thank you.

Tested and it worked. Saves me a ton of time now.

Consider this SOLVED.

[Richard Buttrey]

Thank you.

Tested and it worked. Saves me a ton of time now.

Consider this SOLVED.

Hi,

That's great.

When you have a moment would you go to the original post and select the 'SOLVED' option from the drop down box adjacent to the title.

Regards