Results 1 to 2 of 2

Thread: compare 2 spreadsheets like recordsets? possible?

  1. #1
    Join Date
    Jan 2012
    Posts
    2

    compare 2 spreadsheets like recordsets? possible?

    Hello,

    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?

    Thanks,

  2. #2
    Join Date
    Aug 2011
    Posts
    542

    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

Similar Threads

  1. How to use Lotus Spreadsheets on Windows 7 64 bit
    By Chinye in forum Windows Software
    Replies: 5
    Last Post: 29-03-2012, 05:14 AM
  2. How to calculate values in different spreadsheets of Excel
    By Shard.K in forum MS Office Support
    Replies: 2
    Last Post: 23-02-2012, 06:18 PM
  3. How to view spreadsheets on dual monitors
    By Rao's in forum Windows Software
    Replies: 2
    Last Post: 08-01-2012, 10:02 AM
  4. How to compare recordsets in access vba
    By Nihar Khan in forum Software Development
    Replies: 3
    Last Post: 24-09-2009, 10:21 AM
  5. How do you link spreadsheets together in excel
    By SADIQ in forum Software Development
    Replies: 3
    Last Post: 31-07-2009, 08:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •