Dependent Drop Down across 5 columns

[imdumb]

Hi there,

First time, long time.

I work in kitchenware and we have a submission form which requires we categorize the data across a number of fields.

I'm trying to set up a group of drop downs (5 to be exact) that are dependent on the previous. Each row in the product submission is an individual product and thus requires it's own individual set of drop downs. I found one tutorial, however it only worked across three drop downs and I don't have the ability (sadly!) to extend it across the remaining two drop downs. I'm using excel 365 if this makes it any easier also.

I've provided a pic of the data for reference, if you might any further detail please let me know.

If any one could help with this I would be extremely grateful, this is one excel problem that's got me stumped.

Again, any help that can be provided would be greatly appreciated.

 

[VincentNL99]

Hi there,

Sorry but I'm having trouble following along.

Is this correct?
In cell A1 there are 5 choices
Let's say you pick option 1

Now cell B1 gives 5 choices

If you would have picked option 2 in cell a1 you would get 5 different choices in b1

And you want that for a1, b1, c1, d1, e1

 

[imdumb]

Hi there,

Sorry but I'm having trouble following along.

Is this correct?
In cell A1 there are 5 choices
Let's say you pick option 1

Now cell B1 gives 5 choices

If you would have picked option 2 in cell a1 you would get 5 different choices in b1

And you want that for a1, b1, c1, d1, e1

pretty much.. the function of this project is to categorise data for a website, so each row is dependent on the field from the previous column. so data provided in second drop down would rely on what i selected in the previous column.

 

[VincentNL99]

And in what column(s) would be the data you are trying to categorise?

 

[imdumb]

And in what column(s) would be the data you are trying to categorise?

it would be on another sheet within the same document.

thank you

 

[VincentNL99]

With what do you want the rows of lists to correspondent?

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Dependent Drop Down across 5 columns
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.