Have a look at Debra Dalgleish's site for method and a sample workbook.

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP

On Wed, 14 Nov 2007 04:43:01 -0800, SteW wrote:

I've got a list of subjects, Maths, English, Science, Geography, PE, etc.

I want to set up a chart with 3 cells having a drop down box, with the list
in.

But, if I've selected one of the subjects in another cell, I want it
excluded from the list so I can't choose it twice.

Sorry for the rubbish explanation, I hope you get what I mean!