Unbeknownst to each other, two of us have been updating a worksheet which has
27000 records and about 10 fields to each record. The changes are not
extensive, but need tobe identified and resolved between the two versions.
The changes could be in any of the rows or columns. I wrote a small VBA
program which ran through 15 minutes for comparing record 1 in Wksheet 1 with
a single column of Wksheet 2. Is there a purely Excel way of identifying the
changes either through coloring cells or using a third spreadsheet? At less
than 15 minutes per column per record. thanks.
--
VSExcel