I was wondering what the best way to compare 2 sheets are in Excel. Now im actually getting the data from Access and exporting it to a Spreadsheet. From there i wish to interrogate it and find out the differences in records. Now the catch is its not a straight compare, information in SHEET 1-cell A1 might exist in SHEET 2 but be in cell A3, so therefore i want it to mark it as similar. (most of the stuff i have come accross assumes that data is the same if its in the same cells only). When this was planned it was imagined that you could put the data into a recordset and itterate through each record (so each row on SHEET 1) and compare with other recordset (rows of SHEET 2)
从原则上看,能否将数据列入Excel的记录? 或某种类似情况?
感谢