I have two data tables that are made of data that comes from two excel sheets within one workbook. I am trying to update phone numbers (data table 1) and emails (data table 2). There are individuals that are duplicates and some that only wish to update one of the options. I’m trying to locate the duplicates based on similar ID to run both of the updates at one time as opposed to updating all phone updates and then all email updates.
You can probably follow the example that i posted here: