Excel Comparison Tool - Recommendation

[JoeRooney]

Hi,

I have a process where I need to compare two excel worksheets for differences. The 2 worksheets should be identical so any differences should be highlighted.

I know there options within excel itself but as this will be a regular process and needs to be undertaken on a large number of worksheets I was wondering would the Mr excel community have any recommendations on excel comparison tools.

Ideally if you could compare entire workbooks containing individual worksheets that would be ideal but worksheet by worksheet would also work .

Any info or tips on this is greatly appreciated.

 

[OaklandJim]

Are there always the same number of rows and columns? If so I can imagine a macro that checks cell by cell and highlights cells in the target worksheet that are not the same as the corresponding cell's value in the source worksheet.

Are the worksheets in the same workbook?

 

[JoeRooney]

Hi , yes every worksheet name , number of rows ,column and cells should be identical in the workbook. Example workbook 1 contains worksheet 1 and worksheet 2 , workbook 2 will also contain worksheet 1 and worksheet 2 and they should be identical. I need to compare that they are and highlight any differences in workbook 2.

 

[Alex Blakenburg]

If you are using an Enterprise version of 365 or professional version of the earlier versions of Excel, you might want to look into whether you have access to the Microsoft Add-In "Inquire" also know as "Spreadsheet Compare".

Here are some references:
Microsoft > Basic tasks in Spreadsheet Compare
BetterSolutions > Excel Add-ins - Inquire

 

[JoeRooney]

If you are using an Enterprise version of 365 or professional version of the earlier versions of Excel, you might want to look into whether you have access to the Microsoft Add-In "Inquire" also know as "Spreadsheet Compare".

Here are some references:
Microsoft > Basic tasks in Spreadsheet Compare
BetterSolutions > Excel Add-ins - Inquire

Thank you, Alex, I will have a look

 

[JoeRooney]

Thank you, Alex, I will have a look

I added the inquire add on and it works great.

 

[Alex Blakenburg]

Glad to hear it. Thanks for letting us know.