ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting duplicates between sheets (https://www.excelbanter.com/excel-programming/418087-deleting-duplicates-between-sheets.html)

[email protected]

Deleting duplicates between sheets
 
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?

Rick Rothstein

Deleting duplicates between sheets
 
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?




All times are GMT +1. The time now is 10:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com