Hi Samprince,

Unfortunately it can't be done this way. The lists are used in a series of dependant drop downs on a shared workbook, where results are summarised in another sheet and the lists may change over time, being added to by users who do not have the skills to make it all neat and tidy.

I wanted to make the workbook 'self managing' in this respect.

If anyone can say that idea this is not feasible then I will just have to live with it but, having experienced the high level of expertise and ingenuity of the forum users, I feel that someone can come up with a solution.

Regards

Ed