Wow! Thank you SO much! It works like a charm.
So my VBA skills are moderate at best. I thought when I saw the code I'd be able to tweak it to apply to Eight different spreadsheets. That unfortunately has not been the case.
Would you be able to walk me through it/be kind enough to come up with some code for it/want me to upload the other 6 spreadsheets?
It would literally be the same task but with 8 spreadsheets instead of two.

Thanks for all your help. You are a lifesaver.

Best Wishes,