NealW

Since I know Excel, and can work fast in it: I fix sync conflicts by row as follows: Make Excel full screenCopy text from one source starting in A1Copy text from other source starting in B1Make column A and B wide (about 1/2 screen each) but leave Col C visibleSelect the entire sheet and collapse row height to best fitScan down the columns and enter a blank cell where needed to keep the column text alignedEnter this formula in C1: =IF(A1<>B1,1,0) and copy it down to the last row with textWhere the formula returns 1 there's a sync conflictI get only a few sync conflicts per year, so I haven't taken the time to make this into a macro.