Hello all,

I have a slight problem that I just can't seem to figure out how to
accomplish.

I have two excel sheets, one is a new master and the other is old
master

The new and old master sheets contain mostly the same data but not in
the same order.

I am trying to simply compare cell A1 of newmaster to all 13 cells in
old master looking for a match and making a note in newmaster column B
of the same row that says either "exists" or "notexist"

So like, if my sheets looked like the following:


NEWMASTER......................................... ...................OLDMASTER
A1
pokemon.jpg....................................... ..................A1
beyblades.jpg
A2
halo.jpg.......................................... .......................A2
pokemon.jpg
A3
bleach.jpg........................................ .....................A3
onepiece.jpg
A4
beyblades.jpg..................................... ..................A4
sailormoon.jpg


I would be left with my newmaster looking like the following:

NEWMASTER

A1 pokemon.jpg..........B1 exists
A2 halo.jpg..................B2 notexist
A3 bleach.jpg...............B3 notexist
A4 beyblades.jpg.........B4 exists

I hope I have explained this well. I have included two files that
represent a teeny snippet of the actual data.

I have tried to do this myself for several days now by taking bits from
a bunch of macros but I am not getting anywhere.

I can compare as if they both had to be in same order, but not with
them out of order.

Thanks in advance for any help I can get on this!

Bill Beecham


+-------------------------------------------------------------------+
|Filename: oldmaster.txt |
|Download: http://www.excelforum.com/attachment.php?postid=3736 |
+-------------------------------------------------------------------+

--
billbeecham
------------------------------------------------------------------------
billbeecham's Profile: http://www.excelforum.com/member.php...o&userid=16286
View this thread: http://www.excelforum.com/showthread...hreadid=398686