Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing spreadsheets
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two spreadsheets part 2 | Excel Worksheet Functions | |||
Comparing two spreadsheets | Excel Worksheet Functions | |||
Comparing two spreadsheets | Excel Worksheet Functions | |||
comparing 2 spreadsheets | Excel Discussion (Misc queries) | |||
Comparing Spreadsheets | Excel Worksheet Functions |