Closed Thread
Results 1 to 2 of 2

Delete duplicate rows from comparing sheet 1 with Sheet 2 and export new data in sheet 3

  1. #1
    Registered User
    Join Date
    05-10-2019
    Location
    Abu Dhabi
    MS-Off Ver
    2010
    Posts
    4

    Delete duplicate rows from comparing sheet 1 with Sheet 2 and export new data in sheet 3

    Hi
    I need have 1 workbook where

    Sheet1 have 4 Column :Code, Particulars1, particulars2, Amount (have revised list with 500 rows
    Sheet2 have 4 Column :Code, Particulars1, particulars2, Amount (have old list with 450 rows


    I required VBA code to compare both sheet1 and sheet2, and identify new rows and paste in Sheet 3 with all 4 columns.

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Re: Delete duplicate rows from comparing sheet 1 with Sheet 2 and export new data in shee

    Administrative Note:

    Welcome to the forum.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here. I am, therefore, closing this thread, but you may continue here in your other thread which you seem to have reworded :https://www.excelforum.com/excel-gen...sheet-3-a.html
    Please familiarise yourself with the rules before posting. You can find them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 08-01-2014, 03:47 AM
  2. [SOLVED] Delete both Original and duplicate rows off data in 1 column for entire sheet
    By Caraexcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-01-2014, 01:33 AM
  3. [SOLVED] Copy only rows with data to second sheet, delete from first sheet
    By Tonomono in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-20-2014, 02:44 PM
  4. [SOLVED] Copy row to new sheet by comparing all rows of two columns on two different sheet
    By torrid in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-15-2013, 07:45 PM
  5. Delete ALL duplicate rows in an excel sheet
    By jlnguyen54 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-13-2013, 08:51 PM
  6. Delete ALL duplicate rows in an excel sheet
    By jlnguyen54 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-07-2013, 02:22 PM
  7. [SOLVED] Copy row from sheet 1 to next row in sheet 2. delete from sheet 1 and move rows up
    By papabob1954 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-16-2012, 09:38 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