Have two different workbooks with company names in columns and looking to
build a formula or macro that will compare each column in each workbook and
return differences.

Yes, it is possible.......however, I personally use a commercial Add-in from
Jim Cone called XL Companion to make such comparisons. It does a super job
of detailing all the differences.

Vaya con Dios,
Chuck, CABGx3



"AMXAH" wrote:

Have two different workbooks with company names in columns and looking to
build a formula or macro that will compare each column in each workbook and
return differences.

I need to be able to do this comparison immediately - no luxury of getting
additional software. Thank you for letting me know of this product, how does
one come by it?
Any recommendations on what to write to accomplish this comparison today?

"CLR" wrote:

Yes, it is possible.......however, I personally use a commercial Add-in from
Jim Cone called XL Companion to make such comparisons. It does a super job
of detailing all the differences.

Vaya con Dios,
Chuck, CABGx3



"AMXAH" wrote:

Have two different workbooks with company names in columns and looking to
build a formula or macro that will compare each column in each workbook and
return differences.