Cascading Drop Down Menus? Is this possible?

Hi,

New here and just a basic user here so bear with me .

Ok I have figured out how to do a simple drop down menu. But basically I have a list of brick types. So what I need is a list of the manufacturers of the brick which you have in a drop down, you then go down that list and select for instance Redland, which then opens another list of bricks that that manufaturer makes.

For example:

Redland
Butterley
Brick Business

If Butterley is selected then next to it another list will appear with the following choices:

Butterley Mayfield Stock
Butterley Charmwood Natural
Butterley Kingsfold Multi Stock
Butterley Kentish Multi Stock

So you would select Butterley Kentish Multi Stock and this is what is displayed in the cell. I need this to all happen in a single cell, not that you select redland then in another cell you select the Kentish Multi Stock.

Is this possible, as I have done this in Dreamweaver but obviously Excel is totally different.

Thanks

Hi,

This site should help

It has a sample spreadsheet

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

VBA Noob