8 Replies Latest reply on Oct 25, 2016 11:13 PM by Gatik Vij

    Join/Combine 4 different excel sheets within a same workbook (Multiple rows)

    Vinay Salian

      Hi,

       

      Hope one of the experts can help me out here or point me in the right direction.

      How do I combine or join  4 different excel sheets within a same workbook. Unique identifier is "Project Name" in all 4 sheets however some of the sheets have multiple records for same project name.

       

      Workbook 1 -  1 record per project (unique project name)

      Workbook 2 - Multiple records per project (i.e 1 project can have 10 risks (10 rows of risk data with same project name)

      Workbook 3 - Multiple records per project (i.e 1 project can have 10 rows of financial data (10 rows of financial data with same project name)

      Workbook 4 - Multiple records per project (i.e 1 project can have 10 rows of Benefit data (10 rows of Benefit data with same project name)

       

      The idea is to combine 4 sheets so I can report on all attributes like Risks, Financials and Benefits for a project.

       

      Thanks

       

      Message was edited by: Vinay Salian

       

      Message was edited by: Vinay Salian Added attachment