Finding new items in the Updated Items list and adding them to the Master
Data list is a fairly easy task.

Finding updated ones may not be quite as easy? What defines unpdated? You
mention having 8 columns of information, so would a change in the data in any
one of those 8 columns for an item on the Updated Items list mean it was a
change?

Can the data in the Cost Centre column appear more than once on either
sheet? I'm kind of picturing that Cost Centre entries on the Master Data
list would each only appear once? And that they may appear more than once on
the Updated Data sheet and you want to update what's on the Master Data sheet
with the latest/last matching entry on the Updated Data sheet?

"unouwanme" wrote:

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