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

Some videos you may like

This Week's Hot Topics