Comparing Data Tables

[DavidV32]

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.

[KaylaC (Kayla)]

You can probably follow the example that i posted here:

How to compare two data tables and add rows if no match

Im trying to filter through two datatables and find any matches were the column A (name) is the same between the two datatables. I have a large datatable (dt1) that containes a list of customer names and the value I run a report and extract that data into another datatable (dt2) If the Name from dt2 = the name from dt1. Then we update dt1 with the value from dt2 If the Name from dt2 <> the name from dt1. Then we add a new row to the datatable (dt3). Right now i have a build datatable (dt3) …