What you are trying to do is better suited for a database. Why do you need to do this in Excel and not in Access?
_________________________
There are two types of vessels, submarines and targets.