Скачать или смотреть Excel Multiple Dependent Drop Downs

Go to http://www.contextures.com/exceldatav... to get the sample workbook with tables and formulas

Select an item from an Excel drop down list, and see only the related items in the next drop down list.
In this example, there are 4 levels of dependent drop down lists, based on 3 named ranges. Add more lists when you need them, without having to create new named ranges.

00:00 Intro
00:24 Source Lists
01:41 Start the Workbook
04:06 Add More Columns
05:59 Named Ranges
06:31 Named Range 1
08:34 Named Range 2
11:45 Named Range 3
13:03 Drop Down Lists
15:23 Get the Sample File

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...

#ContexturesExcelTips