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