Apologies for the delay in replying to this one. It was trickier than at first it seems.
To solve this I have created a custom Macro that you can use, please take a look at the attached file. It should be pretty self-explanatory but here's a video showing it in action.
If this is useful I may release it publically and record a short tutorial to help out other users.
Please let me know if you have any further questions.
All the best,