Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



compare 2 spreadsheets like recordsets? possible?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 14-01-2012
Member
 
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,

Reply With Quote
  #2  
Old 14-01-2012
Member
 
Join Date: Aug 2011
Posts: 534
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
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 05:14 AM
How to calculate values in different spreadsheets of Excel Shard.K MS Office Support 2 23-02-2012 06:18 PM
How to view spreadsheets on dual monitors Rao's Windows Software 2 08-01-2012 10:02 AM
How to compare recordsets in access vba Nihar Khan Software Development 3 24-09-2009 10:21 AM
How do you link spreadsheets together in excel SADIQ Software Development 3 31-07-2009 08:09 AM


All times are GMT +5.5. The time now is 12:50 AM.