How can I compare data between 2 workbooks and delete if matching under certain criteria

  • Hi


    First of all ive posted here but had no response https://www.excelforum.com/exc…n-7-days.html#post5663938


    What it is I have 2 workbooks that has data and the layout of it is the same in both books.


    Workbook 1 has data that has had some used and deleted from sheet. Workbook 2 has new data and the old data ive used redownloaded. This is where I need to compare the 2 sheets and delete the used data from the new download.

    Book1 (3).xlsx

  • alansidman

    Added the Label Cross Post

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!