Jim,
This works a treat. Have now added as a VBA module, I just need to
work out how to add on the end how to delete the relevant rows
automatically, rather than using autofilter.
Cheers for you help Zack