Autofilling Tables based on Criteria

[Miner]

I have attached a file for use as an example to the problem I am having.

Basically, what I would like to do is type in a store number in the tab labeled "table", and have all of the cashiers for that store listed in the table below. The "data" tab contains all the stores and cashier #s.

Thanks!

[NBVC]

In C2 of Data tag:

=COUNTIF(A$2:A2,Table!$B$3) copied down

in D2:

=Max(C:C)

then in the Table tab, A6:

=IF(ROWS($A$6:$A6)>Data!$D$2,"",INDEX(Data!B:B,MATCH(ROWS($A$6:$A6),Data!C:C,0)))

copied down as far as you need.

[Miner]

Thank you, O God of Excel!