Hi Leith,
I will be using the data validation list to make the selections. What I have done is placed all my main criteria in column A and depending on what the person selects they will be given the options in column B to match. To be honest I don't want to capture a tonne of information just the basics to begin with. I'm currently using excel 2007.

If you think using a different option would be easier please go ahead and suggest, this is something new to me and just beginning to learn so all the help and knowledge you can pass on I would be more than grateful.


Cheers