UPDATED - Clensing data using a macro and separating already processed data

Hi

I have removed the last post as it was becoming slightly confusing and have re-written what I need below to hopefully make my request a bit clearer – hope this is ok and that someone is able to help

Unfortunately I am completely useless when it comes to macro's and I need to add two buttons to a spreadsheet that I am currently building. I have attached an example of the sheet I am working on and I will try to explain as briefly as possible what the sheet is used for and how it works then explain what I need the buttons to do.

THE UNIQUE FIELD WILL BE THE ARN number in the "ARN" COLUMN.

Each week / month I will get updated data which I will paste into the "updated data" tab. I then have a formulated tab that pulls through the information, performs some checks then calculates payments. Some records will be ready to be paid and some won’t. Anything with a total claim amount will need to be paid so….

1st button - Once I have pasted my data in to the “updated reports” tab and the “formulated” sheet has calculated I need a button that.
• Copies only rows that have a total claim amount (copy from column a to y) on the “formulated” tab
• Pastes special values (and formats if possible) into the “paid” tab
• Deletes the relevant rows (any rows from that have been copied across from the formulated tab to the paid tab).
• This will just leave data (in the formulated tab) with no total claim amounts

The following month / week I will receive another download which I will paste into "Updated reports" on to the bottom of the remaining data. This data will contain records that have already been paid (and removed) and once the formulated tab has calculated these records will show in the duplicate column so....

2nd Button - Anything that has a total claim amount and has a duplicate flag needs to be deleted from the updated reports sheet so it is not paid twice.

I would then run the 1st button from above again and repeat the process so the paid values going into the paid tab would have to follow on into a huge list if that makes sense ?

I hope that this all makes sense and someone is able to help me - you have all been really helpfull in the past and this would be a great help

Please let me know if you need more info or a better explanation

Thanks so much for any time and help spent on this

Al

Another explanation of the 2nd button if it helps

The 2nd button

Basically once the macro button 1 has been run I would close the sheet and then open it again to run another payment run say a month later. When I take the latest report and dump it into the "updated reports" tab some of the lines will be duplicates and will already be in the "paid" tab so need to be removed before I run the above macro again. the duplicates would be identified by any row with a total claim AND something in the duplicate column. Any rows that match that criteria would need to be deleted from the "updated reports" tab as above ?

EXAMPLE UPDATED.xls

I have tried it just now but I can't seem top get it to work.

There are two in there - do i need both (if so which one first ?) or just one

I have tried them numerous times and in various orders and can't seem to get it to do what I need it too. It seems to mix up the data, specially if I delete whats already in "paid" and try to start from scratch

Thank you for sticking with me on this one

If you could take a look and come back to me I would be very grateful

Thanks again

Al