I have to compare two Excel files for data consistency. Both the file have equal number of column with equal records on it. My job is to find the data in both the excel files are 100% similar. Record on one file is around 1,00,000. Is there any way i can validate those record on both the files manually or is there any script in Excel I can run to validate those record in two different Excel File?
If Yes can any one give me the detail step by step process of validating two excel file manually? Also if there is script that can be run can you give me the script code and step by step process of how to run it. I would really appreciate if i could get some solution. I have a task to be submitted next week i.e Jun 10, 2016