Crew Delta Macro to compare two excel files dynamically

[Vaib]

Hello,

I need to compare two excel files dynamically. Can someone please help me with the Crew Delta Macro or any other macro that would help me compare the 2 excel files that I input.

[Felipe_Ribeir0]

Hi @Vaib 

I use the Expected Equal (CreW macro) to do it. Download it here http://www.chaosreignswithin.com/p/macros.html

If the two datasets have the same columns and the same data for each row, it will run without errors

If one of the two datasets has different columns than the other, it will send you an error

If one of the two datasets has different rows than the other, it will send you an error

[Vaib]

I need it to call out which column of data is not matching in the output. So, it needs to compare data in each of the rows/columns and provide kind of a true/false output at a column level. 

[Felipe_Ribeir0]

If you dont find a easier path, you can adapt this macro to do this

[12415404]

Vaib -  Did you ever figure this out? 

Thanks! 

-NJL