ExcelBanter - View Single Post - create 3 drop down menus in Excel, each relating to previous

Take a look at:

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

HTH

"ExcelDropDownQ" wrote:

I need to create 3 different drop menus, each has to relate the previous data:
Eg., column A has 4 pieces of data,
column B has 16 pieces of data, but only certain data refers back to one of
the data elements in the column A.

So if I choose the 1st data element in Colum. A, rather than all 16 data
elements in Colum. B showing, it should only show what directly corresponds
to the 1st data element in Colum. A.

Thanks for any help...