@jeffrybrown Thank you so much for adding the macro. I have taken a look at the link to help me add it and I am really struggling.

I am on excel 2016 and the ctrlF11 opens a macro tab. I cant get the VBA to open - Have tried ctrl r. SO , in short i dont know how to use the macro.

I have added it to the macro sheet that opened and tried adding it to the actual worksheet ( which it will not paste to )

On the macro sheet, it appears over 10 rows - but from here I am really lost.

Can you guide me please?