Hello all, I'm looking for a macro to sort ranges based on a recurring word in column W. In column W I have a word ("Wave 4") and every time I see that word, I want to sort the range based on the values in column W from big to small. And then it has to look for the next Wave 4 word and do it all over again. Allow me to visualise below. You see that"Wave 4" is in cell W6, W19 and W 32. So I want to sort range T6 to W13 based on the values in column W (already done here). Then I want the macro to look at the next "Wave 4" and do the same again. Is this possible?This would be a tremendous help, thanks in advance.