Thanks joe,

I still get errors.

Maybe I should make this easier for everyone. Lets forget about putting
the exists message in there.

Let's just say I have two excel files. New has all the data I need, and
old has some of the data but is has been cut off.

How can I compare cell A in new to cell A in old and if they match copy
cell C from new to cell C in old?

I think I have made it as simple as possible. I don't mind several
macros that I must run in sequence if it will make it easier.

Both excel files have mostly the same data but not really in the same
order.
It's real important that cell A2 gets compared to all cells in A and
then cell A3 to all cells in A, etc....

I just want to take the good data from cell C in new and copy over the
bad data in cell C of old, but cell A must match in both otherwise the
data will become mixed and corrupt.

Maybe it's just not possible. Maybe I don't know how to explain it well
enuff.

Thanks Joe, I'll be trying to get what you gave me to do what I need.
But until then I welcome all help!!

Bill


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