Hi...

Basically..

i have a worksheet with 2 sets of data, each set of data has 8 columns. The
first set of data is the 'master data', the second set is the 'updated data'.
The first column of each set of data is called "Cost Centre".

i have set up if statements to compare the 2 sets of data to find, which
item(s) of the 'updated data' are new/amended from the 'master data'.

for the new data i want a macro that can copy the new item(s) from the
'updated data' and paste it at the bottom of the 'master data'.

then i want another macro to search the "Cost Centre" column in the 'master
data' to find the matching "cost centre" and replace the 7 remaining colums
with the amended item(s) from the 'updated data'.

Does this make sense, would really appreciate any help/guidance with this.

many thanks

Ryan