I need a macro to group rows based on values in a specific column.
I have a dashboard with data from row 21 to row 5000. The cells in column GM have the following values: "Hide", "Not Hide", or are blank. The data is sorted based on values in columns A, B, and C. As a result, there is no inherent order to the "Hide" or "Not Hide" values in the cells in column GM.
I need a macro to go down column GM, and group any row where the value in column GM is "Hide". In some cases, only a single row will be grouped with a "+" sign. In other cases, consecutive rows will be grouped as such.
I want to go with grouping rather than filtering because with grouping, data hidden along the range of the dashboard is more readily accessible.
Any help would be greatly appreciated.
Thank you very much.
Bookmarks