[SOLVED] Creating Lists Based on Other Lists

Okay, so I am working on a template that uses Validated Lists to allow users to select from Category, Brand, and Sub-Brand. There are only 3 categories, so that drop-down list is easy to select from, but when you get to the Brand list, there are quite a few to choose from, so I was hoping that I could separate the Brand list to only show the Brands that coincide with the Category that was selected. Then do the same for the Sub-brand list, based on the Brand list.

I don't know if this needs to be done using VBA or just formulas.

Any ideas or links to websites?

-Amy Kate



I use Excel for Mac 2004, btw.