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