+ Reply to Thread
Results 1 to 5 of 5

Copy unique values and paste to another sheet

  1. #1
    Registered User
    Join Date
    12-01-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    99

    Copy unique values and paste to another sheet

    I need help for a VBA code to remove duplicate from one sheet to another sheet.

    My 1st sheet contains the “raw” data starting from row “A8:B65000” (2 column). The sheet name is “Data”

    On the 2nd sheet, the unique data will be copied starting at row “A12:B” (up to the last row) The sheet name is “Unique”.

    How it works:
    Data sheet – On this sheet the data is keyed every day.
    Unique sheet – When I click on this sheet, only the unique data from the DATA sheet will be copied into this sheet, meaning all the data from DATA sheet minus the duplicate)

    Thank you all.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Copy unique values and paste to another sheet

    Do you need to check for duplicates in column A with column A, column B with column B, or both?

  3. #3
    Registered User
    Join Date
    12-01-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: Copy unique values and paste to another sheet

    Thanks for your prompt response.

    I need to check BOTH (2 columns)

  4. #4
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Copy unique values and paste to another sheet

    I'm still not clear on which columns to compare to but try this:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-01-2012
    Location
    Washington DC
    MS-Off Ver
    Excel 2007
    Posts
    99

    Re: Copy unique values and paste to another sheet

    Thanks for your prompt response.

    It works fine but with the following revisions:
    1. When you changed some data on the data sheet, it does not over write the unique sheet, maybe you can add a code to clear unique sheets every time the macro is triggered. (or any suggestion)
    2. Can you add a code that when you select the unique sheet, it will run the macro automatically.
    3. Also, can you add a code to sort the unique sheet.
    4. I tested it at 50000 rows and it is slow, any other way to speed it up?

+ 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] VBA Dynamic way to copy and paste unique values
    By Joakim1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-07-2014, 07:31 AM
  2. VBA code to select all data then copy and paste all unique value to another sheet
    By ahs004 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2013, 09:07 AM
  3. Copy & Paste Unique Values
    By boiler2003 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2012, 09:08 AM
  4. Copy and paste unique values to another worksheet
    By gsrai31 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-28-2009, 11:44 AM
  5. Copy & Paste Unique Cells Values
    By Michael168 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-01-2005, 07:14 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1