Hi Rob,

Thats fantastic - thanks for all your help. I've put it into my main workbook and it does the the job great. I do need to make a few alterations for it to do exactly what I need. I want to assign some macros to a few buttons which I can do, then I'd like to be able to do the deletes within the worksheet itself (I'll then cut and paste the results into a word document) + an undo macro so I can do the same thing with different data. I also like to do the same thing you did, but on a different workbook rather than worksheet, so I can email it on a small file to someone.

Can you recommed a good book for learning this kind of thing so that I can be less reliant on experts such as yourself ?

Many thanks once again for this

Mike