auto populate

[Rstaur]

hi,
I am looking for a way to deal with the following:
I need to autopopulate a range of cells based off of a selection from a drop
down menu. The drop down menu selections use the indirect function linked to
a previous drop down menu. For example, the drop down menu may have an
airport designation such as DFW. DFW is a name that contains a list of
machines (say 10 machines in a1:a9). I want to autopopulate a range of cells
so that when I choose the airport code, the machine #'s populate down a range
of cells based off of the airport code. All of the airports codes are named
and have a list of machines linked to the name.

 

[Don Guillett]

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