You'll find that you'll get better answers if you clearly define the
question.

What data? Compare how? Move where?

The way your question is worded, it would seem that if the letter "a" (for
example) appears anywhere on the first worksheet and also appears anywhere
on the second worksheet then you would move it to a random location on a new
worksheet. I'm sure this is not what you mean.
__________________________________________________ ____________________

"Adurr" wrote in message
...
I need to create a formula or a Macro that compares data on one worksheet
and
it compares it to another worksheet and if it finds a match moves it to a
new
worksheet. I tried using the index and match functions but neither seem
to
working very well for me. Can anyone help give me an example?

Thank you