Hi all

Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a
sheet called Previous around 5000 rows records.
Both have 31 columns and identical column headers

On the 2010 sheet there are records that have changed, how do I get the
changed records details onto and overwite the same record on the Previous
sheet.

Not sure if it would help but each record has a unique reference number.

How do i do this ?

Hope this makes sense
thanks for any help offered