My problem is that I have one sheet with all the information, and
another with a subset that I want to be able to strip from the larger
one. That is, If on B, then remove from A.

Any suggestions?

The entries on B that you want removed from A are what... just one of the
columns from A or the entire row from A? In other words, what is being
matched up... one column's entry or the entire row? Also, what do you want
removed from A... the entire row or just the cell(s) that match(es)?

--
Rick (MVP - Excel)


wrote in message
...
My problem is that I have one sheet with all the information, and
another with a subset that I want to be able to strip from the larger
one. That is, If on B, then remove from A.

Any suggestions?