need to compare two lists and identify cells with same numbers in

Giganews Newsgroups
Subject: need to compare two lists and identify cells with same numbers in
Posted by:  Bockhamptoner
Date: Wed, 3 May 2006

I receive a list of numberic incident numbers every day and need to write a
macro to compare yesterdays list to todays list to identify which are new
numbers. Would also like to run it the other way round on yesterdays list to
identify which numbers are missing from todays list so that I can easily
check that calls have been closed properly.

Replies