Help on comparing two data on two worksheet
 

Hi guys
I have two large data includes numbers and character (.txt files).
I was just wondering what is the best way to compare those two data and
list out any changes between the two files.
Appreciated

Thanks

Kenny email :


---
Message posted from http://www.ExcelForum.com/

Help on comparing two data on two worksheet
 

open each in excel in separate sheets.

insert column A in each

label the cells to indicate the source (fileA or fileB as an example)

Make a copy of the first sheet.

select the data from the second and paste below

sort this sheet using whatever columns would make sense.

examine for differences.

--
Regards,
Tom Ogilvy

"kphan78 " wrote in message
...
Hi guys
I have two large data includes numbers and character (.txt files).
I was just wondering what is the best way to compare those two data and
list out any changes between the two files.
Appreciated

Thanks

Kenny email :


---
Message posted from http://www.ExcelForum.com/