Hi Jack

Happy to help you with this.

But you need to post before and after spreadsheets so we can see what you need.

The programming is relatively easy but will involve macros using several for next loops.