Drop down list

R

Ray

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
 
B

Bob Phillips

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)
 
Top