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.
Last edited by amyxkatexx; 03-01-2010 at 12:41 PM.
See this link on Data Validation -- Create Dependent Lists
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Thank you so much!
This is going to make me look like a genius at my job!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks