Compare Sheets Automatically

Comparacao_Automatica_de_Planilhas.xlsm makes the comparison between two spreadsheets in the same file (workbook). It is possible to define which rows and columns are to be compared. It is also possible to define the relationship between the columns, if they are in different orders in each worksheet.

The Comparacao_Automatica_de_Planilhas.xlsm can be downloaded here. The file has two example worksheets and the comparison parameters are already defined. To perform the comparison, just click the Compare Worksheets button. Then, 4 spreadsheets will be created with the results of the comparison.

If the comparison is simpler, just use the Comparison_Automatica_de_Colunas.xlsm detailed here.

Remember to enable macro execution in Excel. A tutorial is available here. If you want to copy a spreadsheet from another Excel workbook, use the tutorial here.

To compare columns in Excel, click here.

To count elements in a column in Excel, click here.

Needing help, leave a message in the comments.

Enabling Macros

Initial Sheets 

 

Results