Adding function without messing up original code

[peter renton]

Hi

I have attached a small wb to explain what i am trying to do

i need columns a,b,e,f,g,h to the a report sheet (sheet2) when populated and then updated when any of these cells are changed
so that when a cost for the first service is entered this would update the row in the record sheet to reflect costs.

The original wb has macros that are started each time the file is opened the auto archives old date according to date

The data copied should by unique to reg number so duplications copying does not occur ( the original macros should stop duplication anyway)

The auto cleanse macro will eventually delete a row when the contract expires but the data in the report should stay

Hope this makes thing clearer

Peter