+ Reply to Thread
Results 1 to 2 of 2

How to merge duplicate rows with some unique data with VBA code

  1. #1
    Registered User
    Join Date
    10-04-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    1

    How to merge duplicate rows with some unique data with VBA code

    I have thousand rows wihich contains duplicate rows with some unique data. I want merge duplicate rows so last column (location) all values remain. It is important the solution is simple and quick beacuse this kind of table is needed to do monthly.

    More precisely what I need.xlsx

    Please help!
    Attached Images Attached Images
    Last edited by katkur; 10-04-2013 at 06:20 AM.

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

    Re: How to merge duplicate rows with some unique data with VBA code

    There is no quick way as it can only be done through looping the range. It is not recommended to merge cells. You are creating potential for future if you are trying to run a looping code.
    Attached Files Attached Files

+ 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] Macro to merge duplicate rows unique values - current macro not working
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2013, 03:42 PM
  2. Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows
    By aimeecrystalaid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2013, 08:43 PM
  3. [SOLVED] merge duplicate lines while appending unique data
    By tiger10012 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-26-2013, 07:41 AM
  4. Conditional copy/merge rows with some duplicate, some unique lead cell value
    By atusing in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-04-2012, 10:17 AM
  5. How to merge duplicate rows of data into one row using macro?
    By s0gra8ful in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2010, 04:00 AM

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