Drop down list

  • Thread starter Thread starter Ray
  • Start date Start date
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
 
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)
 
Back
Top