Grouping by Indent using VBA

[KelMich65]

Goal: To use a macro to group my data based on the detail information being indented.

I have the following in Column A of a worksheet:

Item description
detail
detail
detail
Item description
detail
detail
detail
detail
detail
detail

Variables:

• The number of Item descriptions from one worksheet to the next
• The number of detail lines below each Item description even on the same worksheet

Constants:

• The first Item description is always in cell A3
• The Item description always starts with a 10- or 11-digit number followed by text
• There is always data in columns A-I, but determining the grouping is only based on what is in column A
• The amount the "detail" is indented is always the same
• There is only one level of indention
• The detail is always below the Item description so "summary rows below detail" will need to be turned off
• I am using Excel 2013

I've seen some macros that do things similar, but they don't match my scenario exactly, and I've been unable tweak them to get them to work for me.

This is my first post ever so if I didn't provide all the information needed, or if it isn't clear, please guide me as to what I need to change/improve.

All help is appreciated!