+ Reply to Thread
Results 1 to 6 of 6

Consolidate Multiple Sheets into Two Master Sheets

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Consolidate Multiple Sheets into Two Master Sheets

    I have a workbook with 15 sheets for different business lines.

    This workbook is a template with multiple empty rows on each sheet.

    I would like to consolidate sheets 1, 4, 7, 10, and 13 into a master sheet that adds only rows that are not empty.

    In addition, I would like to consolidate sheets 2, 5, 8, 11, and 14 into a master sheet that adds only rows that are not empty.

    I believe this can be done with VBA, but I don't know how to do that.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,912

    Re: Consolidate Multiple Sheets into Two Master Sheets

    Plz explain about : You mentioned 15 sheet.
    > But sheet 3,6,9,12,15 (diff every two sheet)
    Can you share/attach sample file with before (original data) & after (required result data, enter manually)


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Consolidate Multiple Sheets into Two Master Sheets

    I can't attach the spreadsheet because of IP regulations, but I can explain further.

    I have fifteen sheets named thusly: 1. Demand Scores - HR 2. Project Dates - HR 3. Service & Portfolio Mgmt - HR 4. Demand Scores - ITSM 5. Project Dates - ITSM 6. Service & Portfolio Mgmt - ITSM 7. Demand Scores - ITOM 8. Project Dates - ITOM 9. Service & Portfolio Mgmt - ITOM 10. Demand Scores - ITBM 11. Project Dates - ITBM 12. Service & Portfolio Mgmt - ITBM 13. Demand Scores - CSM 14. Project Dates - CSM 15. Service & Portfolio Mgmt - CSM

    These spreadsheets are for use by individual business lines for the prioritization of demands and projects. They will be managed by a central Program Management team, who will require consolidated information from each of these 5 business units. I'd like to take all the Demand Scores sheets, from all the business lines, and combine them into one master Demand Scores spreadsheet. I'd also like to take all the Project Dates sheets, from all the business lines, and combine them into one master Project Dates spreadsheet.

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,912

    Re: Consolidate Multiple Sheets into Two Master Sheets

    In this case you can enter dummy data & attach the same.

  5. #5
    Registered User
    Join Date
    01-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Consolidate Multiple Sheets into Two Master Sheets

    That works. Thanks so much in advance!
    Attached Files Attached Files

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,912

    Re: Consolidate Multiple Sheets into Two Master Sheets

    Idea not clear. can you mentioned manually required data in respective sheet in specific location (color code for required as : "Green")
    From which sheet data extract and where. Give some more specific example.
    One suggestion : Instead of separat sheet, kindly maintain in one sheet.
    Your sheets "Demand Scores - HR", "Demand Scores - ITSM", "Demand Scores - ITOM", "Demand Scores - ITBM" & also other two sheet each group is same structure.
    if you reduse sheet name and in those sheet add additional reference name its more clarity. Also i notice that you have some column is blank & also merge cells, thats not right pratice in excel. Try to avoid blank column, row, or merging cells.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Consolidate 5 sheets into one master (Same Range and headings)
    By cmorten82 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-21-2016, 06:14 PM
  2. Consolidate several sheets data in a master sheets
    By amy03 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-24-2016, 06:42 PM
  3. [SOLVED] How to consolidate all data from multiple sheets into a master table.
    By marcusduton in forum Excel General
    Replies: 0
    Last Post: 02-26-2015, 11:55 PM
  4. Replies: 1
    Last Post: 07-17-2014, 12:01 PM
  5. Consolidate all the sheets into one master sheet
    By vignesh rocks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2013, 08:41 AM
  6. [SOLVED] Consolidate Multiple Sheets into Master
    By megmer in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 11-18-2012, 12:56 PM
  7. Replies: 0
    Last Post: 07-20-2012, 04:44 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1