Combine Columns From Multiple Sheets To One Sheet

[Portucale]

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,

[Excel Fox]

So you want them to be consolidated in to one single sheet, which means the should come one below the other, but based on the different columns you've highlighted.

[Portucale]

what I need is a consolidate sheet where the data from the other two sheets will be consolidated but the columns which aren't comum to bth sheets still visible and filled with "0"

Consolidated sheet headers:
Column 1, Column 2, Column 3, Column 4, Column 5, Column 6, Column 7

Hope I explained what I want to achieve :-)

[Excel Fox]

So will there be just two sheets? Also, the number of rows in each sheet will be the same?

[Portucale]

Hi,

There will only two sheets but the number of rows may be different...

Sheet 1
Month Payroll UserID Name CELPayroll CELName CurrMth Mth1 Mth2 NPSScore NPSPayment
Sheet 2
Month Payroll UserID Name CELPayroll CELName CurrMth Mth1 Mth2 QAScore QAPayment

As you can see NPSScore and NPSPayment is only in Sheet 1 as QAScore and QA Payment is only in sheet 2, ideally I would have a "Consolidated" sheet with columns

Month Payroll UserID Name CELPayroll CELName CurrMth Mth1 Mth2 QAScore QAPayment NPSScore NPSPayment

and with the complete data from both sheets,

Thanks,

[Charles]

HI,

It may help in confusion if you attach a sample of your request.
Show a before an after example.

[Excel Fox]

So why don't you just use a VLOOKUP formula in one of the sheets?