Hi
Can be done by VBA, please share your text file sample
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pavan Kumar
Sent: Apr/Mon/2012 05:48
To: excel-macros
Subject: $$Excel-Macros$$ - Compare two batch Files( Text File
Hi,
Try below code,
Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet)
Dim r As Long, c As Integer
Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer
Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String
Dim rptWB As Workbook, DiffCount As Long
Application.ScreenUpdatin