ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Drop down list from another drop down list (https://www.excelbanter.com/excel-discussion-misc-queries/78766-drop-down-list-another-drop-down-list.html)

Sallad

Drop down list from another drop down list
 
I would like to know how to setup another drop down list in the next cell
from whatever text is selected from the original drop down list beside it.
It seems easy but I can't get it to work in Excel. Thanks

Dave Peterson

Drop down list from another drop down list
 
You mean where the second cell's list depends on what was chosen in that first
cell?

I'd use some of the tips at Debra Dalgleish's site:
http://www.contextures.com/xlDataVal02.html

Sallad wrote:

I would like to know how to setup another drop down list in the next cell
from whatever text is selected from the original drop down list beside it.
It seems easy but I can't get it to work in Excel. Thanks


--

Dave Peterson


All times are GMT +1. The time now is 06:59 PM.

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