Hi TM Shucks, I've tried your VBA - it works perfectly on my test data which was a previous day's live data so it seems to be OK. I'll try it on some (copied!) live data next week and let you know if I have any issues.
I'll mark this now as solved; if I need further assistance on this topic I'll open another.

To everyone that has contributed, thank you all so much; everyone will get an "add" to their reputation...
Kindest regards
Mike