+ Reply to Thread
Results 1 to 5 of 5

Consolidate multiple rows that have similar names into one row in another workbook

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    28

    Consolidate multiple rows that have similar names into one row in another workbook

    Hello all,

    I need to consolidate data from multiple rows of one workbook into a single row in another workbook. Ideally I would be able to consolidate these rows:


    Any help you could provide would be incredibly appreciated!

    Thank you
    Attached Images Attached Images
    Last edited by brgr4u; 10-23-2013 at 10:50 AM.

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Consolidate multiple rows that have similar names into one row in another workbook

    no jpg please, but xls files
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    02-20-2013
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Consolidate multiple rows that have similar names into one row in another workbook

    I am trying to get VBA code to consolidate the data in this book into another workbook where column A 'Customer Name' is 'LKQ' and each column is a summation of the original data. There are approximately 2500 cases like this I need to work through.

    Thank you!

    lkq raw data.xlsx

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Consolidate multiple rows that have similar names into one row in another workbook

    I am assuming you have multiple sheets. I have created a summary sheet where all the data from each sheet will be merged.
    It does not matter if it is a single sheet.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-20-2013
    Location
    Indianapolis, Indiana
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Consolidate multiple rows that have similar names into one row in another workbook

    Sorry about that, it works great!

    Thank you!!
    Last edited by brgr4u; 10-21-2013 at 02:03 PM.

+ 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 cells with multiple names into a single column with one name per cell
    By rbtx70 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2013, 12:16 PM
  2. [SOLVED] Macro to check if folder contains excel files with names similar to This Workbook
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2013, 07:54 PM
  3. Consolidate multiple names/values in a range.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2011, 04:41 AM
  4. Replies: 4
    Last Post: 07-10-2011, 06:57 PM
  5. Replies: 2
    Last Post: 03-30-2011, 02:27 PM

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