Multiple Conditional (Dynamic?) Dropdown Boxes HELP!!!!!

**Stephen_Malley** · 06-05-2014, 08:42 AM

Hi

I'm trying to incorporate multiple conditional (Dynamic?) drop down boxes to enable me to get an appropriate code at the end of the process. This will be used to product data entry and the code will tell Amazon where to post the product. I have many thousands of codes that i need to access and the easiest and most accurate way is to break down everything in to category and sub categories until I eventually get the code I want for that specific product.

for Example:

1730708031 Clothing/Baby/Baby Girls 0-24m/Hoodies & Tracksuits/Tracksuit Bottoms

To return this code I would want to select Clothing, which returns a list which includes baby which in turn will give me a list that includes baby girls and so on and so on until I can select Tracksuit bottoms that will return the code.

Each list is dependent on the previous choice

As I have thousand and thousand of potential codes creating range list for each potential category and sub categories is not really feasible and would be very difficult to maintain when changes occur.

With this in mind I have created a code list that breaks the above example so that each category is now in it's own cell and there can be upto 8 (as I've seen so far) potential conditional categories before you return the code and ideally I would like to use this as it very easy to create and update. (see attached)

Any ideas how I can achieve this? I thought I might be able to use filters to return the appropriate list each time but don't know where to begin. Any help would be great as I'm tearing my hair out!

ClothingCodes.xlsx

Many thanks

**Tsjallie** · 06-05-2014, 09:55 AM

Basically search-and-replace is what you need.
The drop-down boxes can be done with autofilter.
You could do this manually with search-and-replace.
Or you could make a userform where you can select a (sub)category and a value together with entering a substitute value and code the search-and-replace under a button.

Moreover you may not want to do this in Excel but in Access instead as this in it's nature is a database application.
But of course it can be done in Excel.

**Stephen_Malley** · 06-05-2014, 10:19 AM

Thanks. Will look into these options. I forgot to say in my post that I want this incorporated into a user form I've already created.

Expect to hear from me again!!