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.
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.
Bookmarks