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.
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.