Hi guys,

Thanks for your replies.

In response to the first reply - I need help with the whole thing!!! Your expert advice would be appreciated

Regarding the second response. I agree, and have some things much harder in code that would be easy in the spreadsheet i.e. countif. Your code looked interesting but the problem is I cant delete any rows as I need other information from the duplicate rows (i.e. the amount) so I just need to scroll down the column and pick up unique items from one column.

I will then use these to scroll down again and get running totals of the amounts from the rows

Hope this makes sense - its Friday, I've had a long week!!!