compare and remove duplicate data from 2 worksheets.

[gmichaels]

I have 2 workbooks, One is a master listing of all store locations. The other shows locations that have purchased a particular item. How do I remove the stores that have purchased the item from the master listing?

 

[Saurabhj]

Hi,

In Master workbook:
1. Use VLOOKUP formula to identify Store Locations which are available in other workbook.
2. Apply filter uncheck option for #NA.
3. Select all visible rows and press Ctl + - to delete.

Thanks,
Saurabh