This, I thought would be easy... I'm still very much a novice but I've been learning and I can do it with array formulas so I thought, VBA shouldn't be a problem... one whole Saturday later.
I have a very large and growing range of data, Sheet("Tally"), the source
And another...