Looking for a macro that will...
- Change Color and Increment Number of an entire row if there are more than 10 lines of the color
- Upon the color change the value of Column C will have a prefix of 1
- If there are are more than 20 the next prefix would be 2 and so on.
I have attached an example. Thanks so very much in advance!
Bookmarks