Hello all,
I am trying to make a VBA code to group certain rows and can't seem to get the logic right. I have attached a file showing my code, example table, and tables grouped as I intend in 3 different tabs.
In my real data, the code works for some of the groupings, but skips others.
I have data in columns 1 and 2. Column 1 is headers, and column 2 is data, I want to group all of the data after each header in Column 1 so that the data in column 2 is hidden in groups and can be expanded and minimized. Each set of column 2 data is of a different size, and each header in Column 1 is different. I've tried to work this out from the similar posts here but can't seem to get it right.
Thank you very much!
Bookmarks