In cell Z1 enter:

=IF(A1=B1,C1,"")
and then copy down
--
Gary's Student


"abmb161" wrote:

I need to match data in cell A to cell B and then if they equal I need to
copy the adjacent cell C to cell X . How do I set up a macro to do this
automatically? I have over 5000 cells to compare and match up.. Can anyone
help? I have Office 2003.