I have about 15 different groupings of data that are color coded (all in one column). So for "User1" button macro sorts by a color and puts it at the top. That still leaves 14 other colors, that I would like to be sorted, but it doesn't matter what color is next. Do I have to use brute force and have 15 different macros to get the color I want at the top, or is there a way to sort by color using buttons that will also sort all the other colors together, but no specific order.
For example, User1 would be green, User2 would be yellow, etc. User1 button brings green to the top, User2 button brings yellow to the top, etc.
Hope that makes sense.
For example, User1 would be green, User2 would be yellow, etc. User1 button brings green to the top, User2 button brings yellow to the top, etc.
Hope that makes sense.