Hi Paul, I added an updated Sample 11 in a previous post. I hope that help. All I want to do is be able to do is create another macro to copy the items in the CrossRef Column 4 from Deployment to MAFFT.
Quote Originally Posted by Paul_Hossler View Post
I tried running the macro and the column headers were changed

I stopped after fixing the first 3:

Capture.JPG

MAFFT col header is 'Device', not 'Devices'
Deployment and MAFFT col headers were 'Montly' and not 'Monthly'
Deployment and MAFFT col header were 'Site/Location', and not 'Site Location'


Since the macros match on column headers to copy data, they have to be matched