Thanks for your reply...

1 - yes, i agree that won't be too difficult, am just unsure of the wording
for the macro though as i want it inserted at the end of the master list so
presume i would need an end function or something similar.

2 - Yes a change in any column would mean it is updated, i have a check on
the worksheet to check which cells are updated and which ones aren't so i
presume i can use the answer from that formula to use in the macro

Basically 8 columns a
1 - Cost Centre (00000 <narrative)
2 - Month (1-12)
3 - Original budget(<figure)
4 - current expenditure(<figure)
5 - income budget(<figure)
6 - current budget(<figure)
7 - CostCode (00000)
8 - CostNarrative (<narrative)

each month the updated data is overwritten by the new data, whcih comes from
a financial system.

3 - THe Cost Centre will/can only ever appear once in either spreadsheet.

Does this make any more sense?

"JLatham" wrote:

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

2 - 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?

3 - 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