Results 1 to 2 of 2

Thread: Need to consolidate data from multiple workbook into one workbook

  1. #1
    Neophyte help_excel's Avatar
    Join Date
    May 2019
    Posts
    1
    Articles
    0
    Excel Version
    MS Office 365 Pro Plus

    Need to consolidate data from multiple workbook into one workbook



    Register for a FREE account, and/
    or Log in to avoid these ads!

    1. There are 26 workbooks with 13 sheets in it. All the workbooks has same tabs and same columns but different data.
    2. I am trying to consolidate 8 out of 13 sheets into one master workbook for some data gathering purposes.
    3. My expectation is to create one master workbook which contains all the 8 required sheets and each sheet should contain data for all the 26 workbooks. Also, these workbooks are password protected. For example: if there are 3 sheets in 10 workbook : Travel , rent and training. Now i want to get travel data for all the 10 workbooks in one sheet and same for rent and training.

    Hope this make some sense.

    Please let me know any additional details are required.

    Thanks!
    Last edited by help_excel; 2019-05-29 at 07:23 PM.

  2. #2
    Acolyte macropod's Avatar
    Join Date
    Mar 2017
    Posts
    39
    Articles
    0
    Excel Version
    2010
    Cheers,
    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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