+ Reply to Thread
Results 1 to 8 of 8

Combining Records together

  1. #1
    Registered User
    Join Date
    10-13-2008
    Location
    Bristol
    Posts
    19

    Combining Records together

    Hello

    I have a problem in excel that is very urgent to resolve. I have a table that contains duplicate records e.g two people living at same address. I want to merge those records whose address field value is same.

    Please find attached an excel sheet that contains the exact data and the exact output that I want. I know it requires VBA coding and I would really appreciate if anyone can help me in resolving this.

    Regards
    Raj
    Attached Files Attached Files
    Last edited by VBA Noob; 10-26-2008 at 03:22 PM.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650
    Hi, Try the attached:- Your modified file with code
    Regards Mick
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-13-2008
    Location
    Bristol
    Posts
    19
    Hi MickG

    Many thanks for your reply.The code works well but the problem is it doesn't display coulmn headings in the result. please have a look at the attachment and let me know what I need to add in my code to display column headings.

    Kind Regards
    Raj
    Attached Files Attached Files

  4. #4
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650
    Hi, Try the attached.
    Delete all Data on sheet (2) then run the code.
    Regards Mick
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-13-2008
    Location
    Bristol
    Posts
    19

    Solved

    Hi MickG

    Many Thanks for your response.My problem is solved now...n it works the way I wanted.

    Thanks a lot..

    cheers
    Raj

  6. #6
    Registered User
    Join Date
    12-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Combining Records together

    I have the same problem can anyone help.

    I have a problem in excel that is very urgent to resolve. I have a table that contains duplicate records e.g two people living at same address. I want to merge those records whose household id value is same.

    Please find attached an excel sheet that contains the exact data. I know it requires VBA coding and I would really appreciate if anyone can help me in resolving this.
    Attached Files Attached Files
    Last edited by hjrobbins; 12-10-2013 at 08:04 PM.

  7. #7
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Combining Records together

    hjrobbins,

    Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  8. #8
    Registered User
    Join Date
    12-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Combining Records together

    Thank You very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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