Creating multiple link dropboxes

**Bowes813** · 08-20-2009, 01:58 PM

I want to create an excel sheet that has dropboxes linked to each other. Example:

I have 3 types of flooring in a dropbox in cell B2 "wood", "carpet", and "tile". When I select "Tile" I want cell C2 to have a dropbox for the types of "Tile". "Tile 1", "Tile 2", "Tile 3". Or if I select "wood" in B2, have C2 populate a dropbox with the 3 types of wood. Any ideas?

**ncmay** · 08-20-2009, 02:20 PM

Try the attached workbook.

**bengaluru** · 08-20-2009, 02:57 PM

Can you explain the data validation =INDIRECT(B2).

**arthurbr** · 08-20-2009, 02:59 PM

Originally Posted by Bowes813

I want to create an excel sheet that has dropboxes linked to each other. Example:

I have 3 types of flooring in a dropbox in cell B2 "wood", "carpet", and "tile". When I select "Tile" I want cell C2 to have a dropbox for the types of "Tile". "Tile 1", "Tile 2", "Tile 3". Or if I select "wood" in B2, have C2 populate a dropbox with the 3 types of wood. Any ideas?

Hi,
have a look here