+ Reply to Thread
Results 1 to 2 of 2

Delete duplicate from one workbook compared to another work book

  1. #1
    Registered User
    Join Date
    11-20-2020
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    3

    Post Delete duplicate from one workbook compared to another work book

    Hello!

    I have columns A and B in sheet1,workbook1, and columns A and B in sheet2,workbook2. The code below checks for the duplicates between the two workbooks by comparing columns A and B in sheet1 and sheet2:
    Please Login or Register  to view this content.
    What I would like to do now is to achieve some sort of reverse engineering of that code above. I'd like to compare the values of column A and column B from sheet2,workbook2 into ALL the sheets in workbook1 and delete them from workbook 1 if it is found.

    Any help would be greatly appreciated. Thank you.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,619

    Re: Delete duplicate from one workbook compared to another work book

    May be something like below code which fills directory with all data from all sheets in Schedule_2.xlsm and then deletes these valkues from opened workbook?

    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. export from 1 workbook to new work book
    By mmikem in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2021, 04:52 PM
  2. Protected workbook vs share work book
    By Throughstream in forum Excel General
    Replies: 2
    Last Post: 01-26-2017, 06:59 AM
  3. Current work book .xlsm convert to xlsx work book then mail
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-26-2016, 09:47 AM
  4. Highlighting duplicate values across an entire work book.
    By PenguinYeltz in forum Excel General
    Replies: 3
    Last Post: 10-24-2016, 09:09 AM
  5. VBA Code for populating cells from one Work Book A to another Work Book with condition
    By ray.kanata in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-22-2015, 03:46 PM
  6. various worksheet from various work book into one workbook
    By Baskar5353 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2015, 05:12 AM
  7. Replies: 4
    Last Post: 06-15-2011, 09:33 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1