Nope. I'm saying don't use excel at all.

I'm saying try using the MSWord (the word processor program in the Office
Suite).

Or try download.com and look for a free text comparison program.



Lillian Lian wrote:

you means Vlookup? but I still can not fingure how to do that, need help

thank you

"Dave Peterson" wrote:

You may find that excel isn't the tool to do this kind of thing.

But you may find that MSWord's tools|compare and merge documents will work ok.



Lillian Lian wrote:

I have two registry key which is test.reg and test-A.reg, the test.reg is
before I install script on the machine, the test-A.reg is after I install
script on the machine, so how can I write the VB script to compare both
test.reg and rest-A.reg, right now on the sheet1 I have test.reg from column
A to B, test-A.reg from column D to E, how can I write the macro, dump the
different in sheet2.

Thank you for the help

Lillian

--

Dave Peterson


--

Dave Peterson