comparing data between 2 worksheets with no unique identifyer

L

Linda

Here is my problem: I need to compare data from one database that I keep,
against a database from a state agency. There is no one field that may be
exactly the same in either database, although there may be some similarities,
such as Vendor name in DB 1 is Marx, Carol and in DB 2 it is Marx Estate.

There are at least 10 fields that I need to analyze. I am using Excel to
compare the data, as most of the State's data is not in Access, but can be
converted to Excel.

Previously, I used a temp to compare records by hand, which is long and
tedious. I no longer have the temp, so I have to find a way to do this
electronically.

Am I just spinning my wheels?
 
O

Otto Moehrbach

Linda
You can use VBA (programming) to search for individual words, like Marx
and Carol. This obviously isn't foolproof but may narrow the overall task.
Post back if you want to pursue this method, and provide some detail about
what you wan to happen when a match is found, etc. HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top