I’m using office 365 and have a workbook with multiple worksheets. Worksheet 1 is a telephone directory that has a table 10135 rows x 20 columns. Worksheet 2 has a similar table 255 rows x 20 columns containing new information that I wish to use to update worksheet 1.
Column A in both...