Dynamically Compare Two XLS Files

[BrandonS4]

Is there a simple way to dynamically compare two files?  I am trying to build a macro that will take 2 excel files and compare them based on the data in each row.  I will be using this for a validation that the two files are exact.

[Emil_Kos]

Hi @BrandonS4,

There have been some popular macros in order to achieve your result but currently, I am not able to find a link.

Alternatively, you can use join tool on each of the columns. If something will not join that will show you that there is a difference in those files. 

If this was helpful please mark my post as a solution!

[BrandonS4]

@Emil_Kos I need something I can use for any two files.  Two files might both have 20 columns and another two files might both have 10 columns.  I need a way to dynamically join both of those.

[Emil_Kos]

Hi,

If you will transpose first you will be able to use join dynamically.

[Emil_Kos]

Hi @BrandonS4,

Check this article. It might give you some suggestions.

Additionally I think you will find there a macro that will do what you need 🙂