See http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Chris" wrote in message
...
No sorry you must have missunderstood me.
The drop down boxes will be reading a list somewhere else on the sheet or
on
a different sheet. The user will be filling in a table and for some cells
I
want them to pick from a list, but then the next columns list will have
updated dependant on what was selected in the first one.

"Tom Ogilvy" wrote:

At least the first part of your question sounds like the built in
Autofilter
capability under Data=Filter=Autofilter.

--
Regards,
Tom Ogilvy


"Chris" wrote:

I am not sure if it is possible, I'm sure there must be a way of doing
this.
what I want to do is have a group of columns next to each other and
have a
drop down box in each cell. the user would select something from the
first
columns list, and then dependant on what was selected, the list in the
second
drop down would be updated and so on.
The way I was thinking was if there was a way of getting it to notice
when
something is selected in the active cells drop down and then filter
the list
by that selection and copy the filtered list into the range that the
second
column reads