VBA Macro to Copy/Paste Contents of Column Based on Header

[JansiJansi]

Hiya guys.

I am trying to build some conversion files for exports from other sites to match my company's imports. I am going to have to identify which header exists in the other company's export and match it to my company's header.

For example:
Export contains header "Product Name"
Import contains header "Title"

These are the same thing, so I'd want to copy the column containing the Product Name header and paste it into the column in the other workbook which contains the header Title.

I'm new to VBA and would appreciate any help. I've looked at some similar files from searches, but can't get it to work for mine. This leads me to believe my brains are dookie because it's a simple macro, I think.

Thank you!

 

[C Moore]

I have a horizontal row of headers that I know I want with a defined name of CopyColumns. I have a formatted table, Table1, that shares the matching headers. This cycles through and pastes each column. Limited rows in my dataset.

    Set copycolumns = Range("CopyColumns")
        For Each cell In copycolumns
            header = cell.Value
            Set pastelocation = cell.Offset(1)
         On Error GoTo skipover:
                Range("Table1[" & header & "]").Copy
                pastelocation.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
                    :=False, Transpose:=False
skipover:
On Error GoTo 0
        Next cell