Results 1 to 11 of 11

Remove duplicates when copying a row from one sheet to another

Threaded View

  1. #1
    Registered User
    Join Date
    02-03-2016
    Location
    USA
    MS-Off Ver
    office 2007
    Posts
    7

    Post Remove duplicates when copying a row from one sheet to another

    Hello,

    I am new to the wonderful world of VBA. I have a mastersheet with data that once updated a user can click the "update" button and the info transfers over to the corresponding sheet. However, when the button is clicked for the 2nd, 3rd, 4th, etc. time, the data duplicates previous data already copied to the additional sheets. I know that I am needing to delete the duplicates, but nothing I have tried so far is working. Help!

    Thanks!
    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. Need macro to remove duplicates from excel sheet after adding the contents
    By Amruta_chintalwar in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-19-2014, 06:43 PM
  2. Macro that would Copy/Paste to new sheet and remove duplicates
    By dani_n88 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-11-2012, 06:04 PM
  3. [SOLVED] Remove duplicates in whole sheet
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 07:31 AM
  4. [SOLVED] Identify duplicates and remove both from sheet.
    By markDuffy in forum Excel General
    Replies: 2
    Last Post: 05-30-2012, 12:09 PM
  5. Replies: 5
    Last Post: 07-25-2011, 09:42 PM
  6. Copy Entire Row into New Sheet, remove duplicates
    By aeh7b in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-17-2011, 05:46 PM
  7. Trying to run a macro to sort and remove duplicates from entire sheet
    By sgmiller in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2009, 10:24 AM

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