Results 1 to 3 of 3

Thread: Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003

  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003

    So I'm clueless about programming, almost clueless. I'm given this excel workbook where there are a list of names and a list of other details (columns). There are names repeated but not all rows have names.

    For example (not allowed to upload excel file) - original excel file
    INSERTS HEADER
    Aaron | detail A | detail B | detail C | detail D
    | detail A | detail B | detail C | detail D
    | detail A | detail B | detail C | detail D
    Betty | detail A | detail B | detail C | detail D
    Betty | detail A | detail B | detail C | detail D
    Aaron | detail A | detail B | detail C | detail D
    Cathy | detail A | detail B | detail C | detail D
    | detail A | detail B | detail C | detail D

    yeah so on and so forth. So you can see that aaron has 2 count but four rows, betty has 2 counts and 2 rows and cathy has 1 count but 2 rows. How do I do it such that for each name, I merge the names into 1 count without merging the rows AFTER copying the header over. It's a loop right? Also, each name copied out must be copied into a new workbook.

    I'm going nuts on the amount of research done online because I don't understand the codes provided. So i would really appreciate if the comments are left next to the line of code to explain. THANK YOU SO MUCH

  2. #2
    Join Date
    Aug 2008
    Posts
    281

    Re: Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003

    I don't have much Idea about VBA programming in Excel 2003 but I still can easily found this application which is what you are looking for.
    Duplicate Remover for Microsoft Excel you can easily remove duplicates from your Microsoft Excel worksheets or find unique entries. Once duplicates are found, you can delete, select, color or copy them, or move to another location (new workbook, new / existing worksheet).

    Just Google what you need to do & I am sure you will find a lot of products or application programs you are looking for excel 2003.
    I hope this helps you.

  3. #3
    Join Date
    Jul 2009
    Posts
    2

    Re: Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003

    Quote Originally Posted by rupak View Post
    I don't have much Idea about VBA programming in Excel 2003 but I still can easily found this application which is what you are looking for.
    Duplicate Remover for Microsoft Excel you can easily remove duplicates from your Microsoft Excel worksheets or find unique entries. Once duplicates are found, you can delete, select, color or copy them, or move to another location (new workbook, new / existing worksheet).

    Just Google what you need to do & I am sure you will find a lot of products or application programs you are looking for excel 2003.
    I hope this helps you.
    hi there thanks for replying! The solution you provided is kind of perfect buttt i'm looking more for codes wise. Any solutions? Do you know how i can search through a column to look for duplicates (after filtering) and merge the cells/delete the value of cells without merging the rows.

    Also, how do i set the code to detect "value" (blank)x2349832 to the next "value"

Similar Threads

  1. How to combine data in duplicate rows in MS excel
    By Virginia in forum Windows Software
    Replies: 7
    Last Post: 10-07-2011, 11:13 AM
  2. Copying Of Rows and Header In new workbook and E-mail
    By winni in forum Windows Software
    Replies: 3
    Last Post: 04-02-2011, 08:20 AM
  3. How can I highlight duplicate rows of excel sheet with color?
    By Sarfaraj Khan in forum Windows Software
    Replies: 5
    Last Post: 08-01-2010, 11:15 AM
  4. How to delete hidden rows in Workbook using Macros ?
    By Dwij in forum Windows Software
    Replies: 4
    Last Post: 21-04-2009, 02:16 PM
  5. Replies: 3
    Last Post: 26-02-2009, 02:51 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
  •  
Page generated in 1,711,644,420.33585 seconds with 17 queries