Search Column Headers and Copy into a Sheet

Hi guys,

Hope you're all well. Am trying to programme a simple Macro and was hoping you could help.

I have one file (Template) with various columns (A, B, C). I want to allow the user to specify an input file (with has some matching columns, A, Z, B, Y). I'd like the Macro to search column A, column B, column C, copy the entire column (including empty rows) and paste it in the Template file. So it will be a case of finding those 3 columns, and copying and pasting into the Template file with the same headings.

I've made a start but missing a few pieces. I've added annotations to help. Hope you can help.

Please Login or Register  to view this content.

Anyone at all?