+ Reply to Thread
Results 1 to 3 of 3

Remove Duplicates from both sheets reading Col B+C

  1. #1
    Forum Contributor
    Join Date
    08-17-2013
    Location
    Asia
    MS-Off Ver
    Excel 2021
    Posts
    273

    Remove Duplicates from both sheets reading Col B+C

    I have workbook (EXcel 2003) having multiple sheets, and I want macro to run on two sheet, say 2DC, and 2DP

    1) Duplicates within each Sheet is Okay, and should be ignored, but, if there are duplicates in both the sheets, based on following criteria, entire row need to be deleted, from both the sheets

    2) Both sheets would have records (rows could vary, one sheet having 1000 rows, while another sheet could have rows record of 500 or 2000 rows), but there are duplicates in both the sheets. Few records in 2DC, would be in 2DP and vice versa, which i want to remove entire rows, from both the sheets.

    3) Row 1 in both the Sheets (2DC & 2DP) should not be considered for duplicates, as they have common header

    4) Duplicates should be found from Row2, in both the sheets taking clue from the combined reading of Column B having text data, and Column C having date data (display format dd-mmm-yy),

    I have searched the forum and found a macro similar to my case, except, a) it only reads one column for finding duplicates from two sheet, whereas i want to have combined reading of Column B & Column C for both sheets to find duplicates, and b) In my case, i want to start comparision from Row 2, (Row1 has header in both sheet, and should not be considered as duplicate)

    The macro is as under, kindly help to tweak the code or new code to meet my objective.

    Please Login or Register  to view this content.
    Source: http://www.excelforum.com/excel-prog...uplicates.html

    My Sample Data file is attached, wherein Duplicates in two sheets are marked in RED, which are required to be deleted from both sheets, and one cell 2DC!B38 and 2DC!C38, which differs on Column C date data, should not be deleted.
    Attached Files Attached Files
    Last edited by analystbank; 01-29-2015 at 03:11 AM.

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Remove Duplicates from both sheets reading Col B+C

    Here is the code which is working for me.
    Please Login or Register  to view this content.
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  3. #3
    Forum Contributor
    Join Date
    08-17-2013
    Location
    Asia
    MS-Off Ver
    Excel 2021
    Posts
    273

    Re: Remove Duplicates from both sheets reading Col B+C

    Perfectly alright, SIR. Thanks a ton

+ 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] function to remove duplicates from different sheets
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-03-2014, 08:03 AM
  2. Replies: 1
    Last Post: 10-23-2012, 09:12 AM
  3. Replies: 5
    Last Post: 02-28-2012, 02:52 PM
  4. Need VBA code to remove entries if there are duplicates (remove them totally)
    By BrandonFromSingapore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-13-2012, 12:50 AM
  5. Replies: 2
    Last Post: 03-20-2011, 11:19 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