A further thank you for taking the time to reply. I looked into your recommendation and realised that auto filters did exactly what I was looking for. If you hadn't pointed the way I would never have found it.