Im hoping someone can help a intermediate Excel user with the following:
Scenario #1: I have a database that's stored on a server. I have an Estimate Wrokbook that requires the product information in that database. Using the information in that database i want to create several drop down lists that are dependent on each other for the information presented in the next list. For example, By choosing 'Purple' in the first drop down, the second drop down will on give me the results that pertain to purple.
Scenario #2: Same as above, except that assuming the programming behind the above may be too complex for me, the database is located in the Estimate workbook.
Attached is a sample of what im looking for. I have intermediate level Excel experience, with very little VBA so anything you give me should be tailored around that. Any help with this would be appreciated!