Does pjwhitfield's solution work for you?

I assumed that the macro will not work for you, because most of the time the amount of data that needs to be processed is huge and this kind of macro doesn't even come close to large scale data processing. Anyway, as I mentioned before, I'm a beginner when it comes to VBA and this macro was fun to write and good practice for me