Compare two separate Excel document lists

[Guest]

I have exported data from two different sources of the business and I need to
now take these two separate worksheets and compare them for similarities and
differences in an automated manner.

How can I do this?

Thank you,

Best regards,

Dave Clark

 

[John Nurick]

Hi Dave,

A good way to start is by going to Google Groups and searching for

"compare+worksheets" group:microsoft.public.excel.*

And next time, ask your question in an Excel newsgroup rather than an
Access one!

On Thu, 15 Jun 2006 14:23:02 -0700, Dave Clark <Dave

 

[John Vinson]

On Thu, 15 Jun 2006 14:23:02 -0700, Dave Clark <Dave

I have exported data from two different sources of the business and I need to
now take these two separate worksheets and compare them for similarities and
differences in an automated manner.

How can I do this?

I don't know, but I don't think that Microsoft Access (the subject of
this newsgroup) would be the best tool.

Please repost your question in an Excel newsgroup. Scroll down the
list of newsgroups on the webpage and find one for Excel.

John W. Vinson[MVP]