Excel VBA - Comparing two columns of data

DragonL · May 10, 2004

I am using Excel 2002, and I am trying to create a macro to compare tw
columns of data and highlight or shade the cells or colorize any entr
that is not in both columns.

I also read something about being able to put a button on the exce
chart that runs the macro. Could someone help me with that too? :

Dave Peterson · May 11, 2004

Chip Pearson has lots of ways to compare two lists.

Some are macros and some are worksheet formulas.

http://www.cpearson.com/excel/duplicat.htm

(I'm not sure I'd start with code. Learning the formula technique may be much
more useful.)

Excel VBA - Comparing two columns of data

DragonL

Dave Peterson