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,