Copy columns based on header (Without header)

Hi guys,

I want to copy some columns to another sheet based on the header. But without copying the Headers itself.
I've attached the file in which I want to do it.

So the columns from sheet1 (A2:M2) downwards, have to be copied to the sheet INPUT range (A6:M6)...
But on sheet1, the order of the columns can be different, or there can be less columns (based on a dropdown list).

Can this be done?

Thanks in advance!

Does this help?

Please Login or Register  to view this content.

Well, this will copy all the columns, but if the column order in the 2 sheets is different, then it will not work correctly I suppose.
Any solutions for that problem?

Try:

Please Login or Register  to view this content.

Works like a charm!
Thanks for the solution John.

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

Oh, forgot 1 thing. I want to preserve the format on the sheet INPUT. Can I use a pastevalues with the .copy method?

Or:

Please Login or Register  to view this content.

Thanks

One last question. Can this macro be reformed in a vba formula, so that I can enter the formula on the INPUT-tab. Which will then give the value of the corresponding column of the sheet1-tab?
Or is there an excel formula that can do this?

You may want to try VLOOK-UP. Click on your help screen and see it that is what you need.