compare and delete

  1. D

    Compare date in a cell to a variable, then delete row.

    Is it possible to compare data in a range of cells to a concatenated variable in vba, if it is found then delete the entire row, otherwise do nothing. For example, range is A:A, value to be located is B27_3/17/2010 variables are test1 and test2 test1 = B27 test2 = 3/17/2010 the concatenated...
  2. M

    Workbook Comparison

    I've got the following code: Sub UpdateReport() Dim wbSource As Workbook Dim wsSource As Worksheet Dim Rng As Range Dim wbMaster As Workbook Dim wsMaster As Worksheet Dim Cell As Range Dim Target As Range Dim r As Long Set wbSource =...
  3. I

    Compare column B to A, delete occurences found in B, list occurrences on column C

    Hi everyone, I have a master list of words on column A . I would like to compare words on column B against list A. If occurrences are found on B, I would like to delete them but also list them on column C for verification. Thanks in advance for all your help. I've received so much help here...

Watch MrExcel Video

This Week's Hot Topics

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
Top