Good morning all. I've searched for a little bit now, but can't find exactly what I'm looking to do. I also posted this question on another board, but received no help.
I am needing macro to Group Rows based on either cell content or cell/row color. A lot of the worksheets I work on usually have 5K+ rows and 100+ columns.
I have done Subtotals, but I don't think Subtotaling will work every time based on some of the data I work with. So, I am using a Pivot to format the data...but now need to Group the data to make it easier for the other users.
I need to Group by the Row Colors without the word Count. Make sense???
I have attached an example file.
Thanks for your time.
Bookmarks