Sheet 1 contains 10,000 customers all uniquely identified by a customer
number in column A, with extra details stretching to column Z. Sheet 2
contains up to 10,000 customer details that are identical to sheet 1 in terms
of customer number, but their additional details might have been changed. I
need a macro that will compare sheet 1 and sheet 2 by customer number. If any
row on sheet 2 is different to sheet 1 then the changed data sheet 2 will be
transferred into sheet 1. Make sense?

This has been driving me nuts...any help appreciated...

Gordon.