Results 1 to 7 of 7

Thread: Combine Columns From Multiple Sheets To One Sheet

  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    11
    Rep Power
    0

    Combine Columns From Multiple Sheets To One Sheet

    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,

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    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.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Oct 2012
    Posts
    11
    Rep Power
    0
    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 :-)

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    So will there be just two sheets? Also, the number of rows in each sheet will be the same?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #5
    Junior Member
    Join Date
    Oct 2012
    Posts
    11
    Rep Power
    0
    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,

  6. #6
    Member Charles's Avatar
    Join Date
    Aug 2012
    Posts
    63
    Rep Power
    12
    HI,

    It may help in confusion if you attach a sample of your request.
    Show a before an after example.
    If you like the answer, please click " * " below Member name to say thanks.

  7. #7
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    So why don't you just use a VLOOKUP formula in one of the sheets?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Replies: 7
    Last Post: 05-15-2013, 02:56 PM
  2. Replies: 3
    Last Post: 05-14-2013, 03:25 PM
  3. Replies: 2
    Last Post: 03-21-2013, 10:38 PM
  4. Replies: 2
    Last Post: 06-14-2012, 04:10 AM
  5. Replies: 1
    Last Post: 11-11-2011, 02:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •