Hey everyone,

I've developed a delightful little macro but have just one littl
problem with it.

The output is a checklist which contains to lists of values in column
and B respectively. The two lists should contain the same value
however small differences can sometimes exist. I would like a macro t
recognise where these differences occur - is this possible.

An example of what imean -

List A List B
(Col A) (Col B)

1 1
2 2
3 4
4 5
6 6

Can i get a macro to report that value 5 is missing from list A but i
list B, and that value 3 is missing from list B but in list A?

Can the result be reported in column D?

Many many thanks for any help :-

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