+ Reply to Thread
Results 1 to 4 of 4

Finding duplicates in column A and copying them to a new sheet

  1. #1
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    2003, 2010, 365
    Posts
    320

    Finding duplicates in column A and copying them to a new sheet

    Hi,

    In column A I have duplicate names and in column B they have different values associated, what I need to do is display only column A's duplicates with there associated value from column B on sheet 2.

    I'm using excel 2003 and vba is my preferred solution.

    Here is some of what I have but it is not working.

    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Finding duplicates in column A and copying them to a new sheet

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Finding duplicates in column A and copying them to a new sheet

    Please Login or Register  to view this content.
    Last edited by Bernie Deitrick; 02-11-2015 at 03:53 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,945

    Re: Finding duplicates in column A and copying them to a new sheet

    Your code skips the first of the duplicates - if the OP needs all the duplicates, then your formula needs to change.

+ 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. Finding text in column B, then copying corresponding value from column A into new sheet
    By antibudger in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-21-2014, 10:45 AM
  2. [SOLVED] Finding data in column a copying to entire row to new sheet
    By ALLEYCAT38 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-05-2012, 04:52 PM
  3. Replies: 2
    Last Post: 08-08-2009, 06:02 AM
  4. Finding duplicates in a column
    By Chris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-26-2006, 08:25 AM
  5. Finding duplicates in a column
    By fergusor in forum Excel General
    Replies: 4
    Last Post: 03-23-2006, 01:21 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