Macro Tool for Data Validation between spreadsheets (Excel)
Description
This Excel based tool compares data (numbers, text, dates) between two spreadsheet in a matter of seconds. Just simply dump the data you want to compare in Data Sheet 1 and Data Sheet 2 and run comparisons. You can name the data sheets as you wish. When you run comparison the output is produced providing you with:
- Any items in Sheet 1 not in Sheet 2
- Any items in Sheet 2 not in Sheet 1
- Summary of side by side comparative discrepancies
- Summary of side by side comparative matches
Tags