delete duplicates match

  1. V

    vba code to delete duplicate rows in range causing error 1004

    I am trying without success to write a vba procedure to delete a duplicate range of cells. The object of the procedure is to define one range of cells and if the code finds a match it should delete the range that matches. This worksheet was imported data from a text file. The error is happening...
    • vba317
    • Thread
    • delete a range of rows delete duplicates match excel & vba excel & vba 2010
    • Replies: 5
    • Forum: Excel Questions
  2. V

    vba code to delete duplicate rows in range causing error 1004

    I am trying without success to write a vba procedure to delete a duplicate range of cells. The object of the procedure is to define one range of cells and if the code finds a match it should delete the range that matches. This worksheet was imported data from a text file. The error is happening...
    • vba317
    • Thread
    • delete a range of rows delete duplicates match excel & vba excel & vba 2010
    • Replies: 1
    • Forum: Excel Questions
  3. R

    Remove Duplicates with multiple criteria --Very Urgent, Need help

    Number Group 26673 VDP-VDW 26673 VDP-VROR 26673 VDP-VROR 26520 TTMS 26520 VDP-VDW 26520 VDP-VDW 26520 VDP-VROR 26520 VDP-VROR 26544 CPS 26544 Customer Central 26544 CPS 26490 CAD AMS 26493 TFAD 26493 TFAD Above is my raw data, I want to remove the...
  4. N

    how to delete rows that have cells with matching contents in column 'B'

    I have a spreadsheet that I need a vba solution for. If a cell in column 'B' matches a cell in another row in column 'B', then delete both rows. Thanks for any help!
  5. J

    Del dublicates

    Anyone who could help me. That macro asks if I want to delete or not. If I choose "not" it leaves current cell red. How can I degree that. If I choose not to delete it should leave that cell as it was in the begin. Please help me. Sub oma() Range("A:A").Interior.ColorIndex = xlNone For i =...
    • Jomu
    • Thread
    • delete a row delete duplicate delete duplicates delete duplicates match
    • Replies: 7
    • Forum: Excel Questions
  6. S

    Deleting duplicates in Sheet2

    I need to create a macro to delete duplicates rows in sheet2 matching all the data in sheet1. For example, i got a list of dispose parts in sheet1 and wish to delete it from master list(sheet2). I'm a beginner and no idea how to utilize excel for solving this problem, as this has to be done...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top