VBA to remove entire row when duplicate is found

shiva_reshs

Board Regular
Joined
Sep 5, 2012
Messages
68
I have two workbook with D column having unique number. How can we remove the duplicate in 2nd file based on 1st file data?
Vlookup cannot work, as when i do Vlook up it picks up the data of 1st record as well on the 2nd record which should be the 2nd vlook up data.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Watch MrExcel Video

Forum statistics

Threads
1,096,360
Messages
5,449,981
Members
405,580
Latest member
MRJT

This Week's Hot Topics

Top