Comparing the two excel sheets using MACRO
Step1:- Create one sample text file with data like below
Sno|EmployeeId|EmployeeName
1|23423|krishnaRaju
2|32423|Ranja
3|45653|venkat
Step2:- Create one sample text file with different data like
below
Sno|EmployeeId|EmployeeName
1|23423|krishnaRaju
2|7456|Ranja
3|45653|yhy
Step3:- Create one excel file and click Alt+F11 to display
the macro space the past the below code
Sub Button1_Click()
'Declare variables here
Dim sh As Long
Dim...