Cascading Drop Down

[zyzzyva57]

The easiest way to ask this question is to start with this short YouTube video on what I want

My question is this: in the video he is using 3 English towns with names of employees in each town to find a name for another list box

What he does works for me, except this: is there a limit to the number of English towns, say 9 towns or 10 going across (towns), down (employees)

This seems to be what I am finding with his technique: 9 "towns", i.e., Column Headers, work fine, but NOT 10 -- I do NOT get to select employees for the 10th town

If there is NO limit, then I obviously have another error

Thank you

 

[ArthriticPanda]

Hi,

I've created a quick mock up of what I think you are looking for. I can access the 10th Town without any errors.

Sheet1

A

B

C

D

E

F

G

H

I

J

K

L

M

1

Town

Employees

Town1

Town2

Town3

Town4

Town5

Town6

Town7

Town8

Town9

Town10

2

Town10

Employee 1

Employee 1

Employee 1

Employee 1

Employee 1

Employee 1

Employee 1

Employee 1

Employee 1

Employee 1

Employee 1

3

Employee 2

Employee 2

Employee 2

Employee 2

Employee 2

Employee 2

Employee 2

Employee 2

Employee 2

Employee 2

4

Employee 3

Employee 3

Employee 3

Employee 3

Employee 3

Employee 3

Employee 3

Employee 3

Employee 3

Employee 3

5

Employee 4

Employee 4

Employee 4

Employee 4

Employee 4

Employee 4

Employee 4

6

Employee 5

Employee 5

Employee 5

Employee 5

Employee 5

Employee 5

Employee 5

7

Employee 6

Employee 6

Employee 6

Employee 6

Employee 6

Employee 6

Employee 6

8

Employee 7

Employee 7

Employee 7

Employee 7

Employee 7

Employee 7

9

Employee 8

Employee 8

Employee 8

10

Employee 9

Employee 9

Employee 9

11

Employee 10

Employee 10

Employee 10

12

13

<colgroup><col style="font-weight:bold; width:30px; *"><col style="width:92px;"><col style="width:109px;"><col style="width:31px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"><col style="width:70px;"></colgroup><tbody>
</tbody>

Data Validation in Spreadsheet

Cell Allow Datas Input 1 Input 2 A2 List =$D$1:$M$1 B2 List =INDIRECT($A$2) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

A link to the file is here is you would like to look at it. Note it is in excel 2003 but the principles remain the same.

AP

https://www.dropbox.com/s/u1hzkhyx85ezntb/Cascading Drop Down.xls

 

[zyzzyva57]

Just what I needed

Your SS was very welcomed, so I have something to dissect to find my error -- Helps to know I am NOT chasing my tail if there were any type of restriction of use

I have made this modification so Cells A2 and B2 can be copied down

=INDIRECT($A2)

instead of

=INDIRECT($A$2)

Thank you