comparing data without unique identifier

L

Linda

I am attempting to compare 2 worksheets (one from another agency) and there
is no unique identifier. Each has a specific grant number; one may be OH
W-13-L-1, the other W13L1. In addition, the vendor name, although similar,
is not usually exactly the same. such as Hunter, J vs. Hunter Estate.

I receive the other agency's worksheet via excel and download mine from
Access.

I could use either program to compare, if I knew what to do! Any suggestions?

Thanks!
 
O

Otto Moehrbach

Linda
You posted a similar question on 18 May to which you received a couple
responses. Did those responses help or maybe give you a way to go? Otto
 
L

Linda

Otto, I was never able to retrieve the messages. When I went to the link
provided in the email, I just got a blank page. I tried looking it up via
key words, but nothing appeared. :-(
 

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

Similar Threads

comparing data without a unique identifier 6
comparing data between 2 worksheets with no unique identifyer 2
VB Editor Access 2
comparing data 3
Help with macro comparing data in worksheets 4
Help needed with Macro designed to compare data... 2
Merging two data bases, each share a unique identifier. 1
Automatically add new info? 1

Top