Hello,
Quite new at this
Please bear with me
I know how to create a drop down list and validate it in say cell A5.
How can I automatically create another dropdown list in cell B5 dependent on
value selected in A5.
example:

If alphabet is chosen in A5 then list in B5 is a,b,c....etc
If numbers is chosen in A5 then list in B5 is 1,2,3......etc

Any help would be appreciated

Thanks
Ray

There are instructions here for creating dependent data validation lists:

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


Ray wrote:
I know how to create a drop down list and validate it in say cell A5.
How can I automatically create another dropdown list in cell B5 dependent on
value selected in A5.
example:

If alphabet is chosen in A5 then list in B5 is a,b,c....etc
If numbers is chosen in A5 then list in B5 is 1,2,3......etc


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

See Debra Dalgleish's site:

http://www.contextures.com/xlDataVal02.html
Excel -- Data Validation -- Create Dependent Lists

--
Regards,
Tom Ogilvy



Ray wrote in message
...
Hello,
Quite new at this
Please bear with me
I know how to create a drop down list and validate it in say cell A5.
How can I automatically create another dropdown list in cell B5 dependent
on
value selected in A5.
example:

If alphabet is chosen in A5 then list in B5 is a,b,c....etc
If numbers is chosen in A5 then list in B5 is 1,2,3......etc

Any help would be appreciated

Thanks
Ray

Ray,

I have a template file for this whereby all you need to do is enter the
values for list #1 and the values for list #2. Mail me if you would like a
copy.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ray" wrote in message
...
Hello,
Quite new at this
Please bear with me
I know how to create a drop down list and validate it in say cell A5.
How can I automatically create another dropdown list in cell B5 dependent
on
value selected in A5.
example:

If alphabet is chosen in A5 then list in B5 is a,b,c....etc
If numbers is chosen in A5 then list in B5 is 1,2,3......etc

Any help would be appreciated

Thanks
Ray

Ray

Debra Dalgleish has instructions for this at

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

Gord Dibben Excel MVP

On Sun, 18 Jan 2004 19:37:55 -0000, "Ray" wrote:

Hello,
Quite new at this
Please bear with me
I know how to create a drop down list and validate it in say cell A5.
How can I automatically create another dropdown list in cell B5 dependent on
value selected in A5.
example:

If alphabet is chosen in A5 then list in B5 is a,b,c....etc
If numbers is chosen in A5 then list in B5 is 1,2,3......etc

Any help would be appreciated

Thanks
Ray