Copy Columns to Different Workbook Based on Header Values

[phelbin]

I'm trying to copy and paste columns in one workbook to another workbook based on matching header values. I can't seem to make it work.

I've attached 2 sample files. I need the data from Example1a to be copied to Example1b, and the macro needs to live in Example1a workbook. Any ideas?

Thanks!!

[LeoTaxi]

my idea, both files has to be in the same directory


Kind regards
Leo

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[phelbin]

Leo, it works great except for one issue. The destination sheet has "Production" and "Prod" headers, and the "Prod" column from the original worksheet is copying to the "Production" column on the second sheet. Any ideas?

[phelbin]

John, your code works perfectly!

Thanks so much!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[LeoTaxi]

correction made


Kind regards
Leo