You need to provide much more detail. What, specifically, does "compare the
data" mean and what are the "results" that need to be written to a log file.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"MajesticM" wrote in message
...
Hello...

I have a list of words in Column A and another list in Column B. i wanted
to
compare the data between the columns and get the results into a log file.
Need some suggestions here