VBA to match headers and copy data from below

[billionaire2003]

Hi everyone,

I am looking for some VBA code to help me with the following problem, it would be great if anyone could help.

I have two excel sheets, both with identical headers except they are in a different order. Sheet1 has data, Sheet2 is blank except for the headers.

In sheet2 I would like to find the column in sheet1 that has the corresponding header, and copy all the data in the column and paste into correct column on sheet2. I would like to do this for all columns in sheet2. For example, the column with header name 'Fruit Type' in sheet2. I would like to find the column in sheet1 with the header 'Fruit Type', and copy all the data in that column into the 'Fruit Type' column in sheet2.


Any help welcomed.

Thanks

 

[mumps]

You are very welcome.

 

[mitchec]

You are very welcome.

Now if only i could figure out how to transfer each sheet to one master sheet rather than having multiple master sheets which i have to copy and paste into one single sheet..... Im using up all my requests and questions here in one go . Im learning how this code works and stepping through it,

 

[mitchec]

Hi everyone,

I am looking for some VBA code to help me with the following problem, it would be great if anyone could help.

I have two excel sheets, both with identical headers except they are in a different order. Sheet1 has data, Sheet2 is blank except for the headers.

In sheet2 I would like to find the column in sheet1 that has the corresponding header, and copy all the data in the column and paste into correct column on sheet2. I would like to do this for all columns in sheet2. For example, the column with header name 'Fruit Type' in sheet2. I would like to find the column in sheet1 with the header 'Fruit Type', and copy all the data in that column into the 'Fruit Type' column in sheet2.


Any help welcomed.

Thanks

Im no expert. but if you use the code shown on the previous page and only type the header(s) you actually want on the destination sheet (sheet2 in your case) it will return the corresponding column and data from Sheet1
Cheers CM

 

[mumps]

Now if only i could figure out how to transfer each sheet to one master sheet rather than having multiple master sheets which i have to copy and paste into one single sheet..... Im using up all my requests and questions here in one go . Im learning how this code works and stepping through it,

If you have only one master sheet, you can hard code it's name into the macro. That is what my original macro did.