Hey all,
I am totally stuck in creating a VBA code to group lots of rows across different columns. As you can see in the tab "Example Data", I have data in column A1, and as a subset, of A1 data in B2-B3, and as a subset of B3 data in C4-C13, and so on in columns D and E. A new 'header' begins in A15, and again in A16 and again in A17, this shows that not all 'headers' in any column have an equal numbers of subsets (some have 0, some 1, and so on) I need to group each data subset under each 'header' across all the columns. I have manually grouped the data as I intend it to be in "Example Result" so you can see how the subsets are all grouped under their headers. I also show it fully grouped/minimized in the tab "Example Results and Minimized". The actual data set I am working with has a few thousand lines and about 11 columns. I was able to get a code working with JUST data in columns A and B but could not carry it across a 3rd or more columns. Any help would be greatly appreciated!!!
Bookmarks