| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to compare two sheet using vba and remove duplicate content?
Hi, need urgent help
I have 2 sheets need to compare and delete duplicate content using VBA For Example : Before Sheet1 A B C 222 Diode D506 333 Capasitor C123 - duplicate row 132 Transistor T525 555 Coil CL121 - duplicate row Sheet2 333 Capasitor C123 - duplicate row 555 Coil CL121 - duplicate row 555 Coil CL121 - duplicate row x 2 444 Diode D444 444 Transistor T444 After Sheet1 222 Diode D506 132 Transistor T525 Sheet2 444 Diode D444 444 Transistor T444 555 Coil CL121 Meaning I have to remove duplicate row inbetween sheet1 and sheet2 base on one to one. Pls help to give me VBA code on how to do. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Two Simple Workbooks & Remove Duplicate Rows | Excel Discussion (Misc queries) | |||
| How do I remove or filter out duplicate records in a sheet? | Excel Discussion (Misc queries) | |||
| Identifying duplicate content in column | Excel Programming | |||
| Cell content elimination; duplicate | Excel Worksheet Functions | |||
| Can excel remove the duplicate rows in a spread sheet? | Excel Programming | |||
Threaded Mode
