Drop down list
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 |
Drop down list
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 |
Drop down list
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 |
Drop down list
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 |
Drop down list
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 |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com