If I were to adopt a VBA approach, do you know how this could work. I'm not accomplished with VBA, but would welcome any suggestions.

Many thanks