compare 2 spreadsheets like recordsets? possible?
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)
Bascially, can i put data into a recordset in Excel? or something similar?
Re: compare 2 spreadsheets like recordsets? possible?
Compare Excel is a small program that can help you for the purpose. I am not sure about the code, but this tool is really very helpful. It helps you to compare the data and create projects. You can generate reports and view it as you want. It works with almost all version of Microsoft Excel. You can notice easy difference between excel sheet.
Use Excel to compare two lists of data
|Tags: excel, microsoft excel, microsoft office, spreadsheet|
|Thread Tools||Search this Thread|
|Similar Threads for: "compare 2 spreadsheets like recordsets? possible?"|
|Thread||Thread Starter||Forum||Replies||Last Post|
|How to use Lotus Spreadsheets on Windows 7 64 bit||Chinye||Windows Software||5||29-03-2012 06:14 AM|
|How to calculate values in different spreadsheets of Excel||Shard.K||MS Office Support||2||23-02-2012 07:18 PM|
|How to view spreadsheets on dual monitors||Rao's||Windows Software||2||08-01-2012 11:02 AM|
|How to compare recordsets in access vba||Nihar Khan||Software Development||3||24-09-2009 11:21 AM|
|How do you link spreadsheets together in excel||SADIQ||Software Development||3||31-07-2009 09:09 AM|