ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   drop downs (https://www.excelbanter.com/excel-discussion-misc-queries/197584-drop-downs.html)

Onecrazyeye

drop downs
 
I would like to create a drop down cell on "Excel 2003" that is populated
according to the selection made on another. For example if on the first drop
down one selects "TREES" then the nest drop down gives you a selection based
on the first choice such as "TALL", "EVERGREENS", "FRUIT", ETC.
If anyone can assist with this I would greatly appreciated since I just
can't seem to figure it out my self and have limited knowledge.

Pete_UK

drop downs
 
Debra Dalgleish shows how to do this he

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

Hope this helps.

Pete

On Aug 5, 9:00*am, Onecrazyeye
wrote:
I would like to create a drop down cell on "Excel 2003" that is populated
according to the selection made on another. For example if on the first drop
down one selects "TREES" then the nest drop down gives you a selection based
on the first choice such as "TALL", "EVERGREENS", "FRUIT", ETC.
If anyone can assist with this I would greatly appreciated since I just
can't seem to figure it out my self and have limited knowledge.




All times are GMT +1. The time now is 08:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com