Results 1 to 8 of 8

Copy + Paste Only New Unique Rows

Threaded View

  1. #3
    Registered User
    Join Date
    03-19-2014
    Location
    Greece
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Copy + Paste Only New Unique Rows

    Maniacb thank you for your time.

    Close enough but this is taking into account only the color and not the date. So if we have lets say a Red for 10/5 which will successfully go to Checked sheet, any other Red will fail to be moved.

    I have updated the code so removing duplicates should take into account both color and date

    rs1.Range("$A$1:$B" & Lastrow).RemoveDuplicates Columns:=Array(1, 2), Header:= _
            xlYes
    Last edited by whitoulias; 05-07-2021 at 05:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy/Paste unique
    By fmoro76 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-13-2021, 05:21 AM
  2. [SOLVED] Copy & Paste all unique values from a range
    By liamfrancis2013 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2016, 07:09 AM
  3. [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
  4. Compare two sheets,copy and paste unique rows based on values in 2 columns
    By ooggiemobile in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2013, 03:58 AM
  5. Copy & Paste Unique Values
    By boiler2003 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-06-2012, 09:08 AM
  6. Repeat Copy/Paste for Unique ID
    By dreicer_Jarr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2009, 12:03 PM
  7. 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

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