Sorry I stated new workbook in the subject line but I meant into a different workbook - mine will essentially look the same as the one that I uploaded here. There will be data in all the other columns between the purple ones as well, which I can't paste over.

Would I essentially have to name each block of purple cells individually and use a macro to run the copy/paste function?