Thanks for the response. I'm afraid that auto filters etc will not work as I need to move the data to a different sheet.

Anybody got any ideas on this one?

Thanks

Tom