help with cell compare in two worksheets

[billbeecham]

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