validation list boxes
 

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

validation list boxes
 

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

validation list boxes
 

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

validation list boxes
 

Since you never specificaly said any of that, I guess I did misunderstood you.

Dependent lists - data validation
http://www.contextures.com/xlDataVal02.html

--
Regards,
Tom Ogilvy


"Chris" wrote:

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

validation list boxes
 

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