Results 1 to 8 of 8

Copy + Paste Only New Unique Rows

Threaded View

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

    Copy + Paste Only New Unique Rows

    The attached code works well on what it is intended to do.

    Rows enter the Incoming sheet via a web query. Then these rows are sorted by removing duplicates and move to Checked sheet. This is where help is needed.

    As Incoming sheet will be updated every 30 minutes or so, eventually after the first, second or even third refresh, the same rows are going to be moved to Checked Sheet again and again.

    Is there a way to prevent this from happening.

    Thank you in advance!
    Attached Files Attached Files

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