Consolidate sheets

Hi,

I am looking to consolidate two worksheets within the same workbook but the worksheets do have a couple of different column names, example:

Sheet 1
Column 1, Column 2, Column 5, Column 6, Column 7

Sheet 2
Column 1, Column 2, Column 3, Column 4, Column 7

As you can see Column 1, Column 2 and Column 7 are concurrent with both worksheets but the others aren't, so is there any VBA which could consolidate the data in the correct columns?

Any help is very much appreciated.

Kind regards,

Send me an excel with expected output in it....

Does this help? Test on a copy to see if it does what you want.

Please Login or Register  to view this content.