Creating Dropdowns and Following On Relationships between Further Dropdowns

Good evening,

Firstly, i'm new to this forum and have came here to try and establish some skills on excel as currently i'm quite mediocre due to never really needing to do anything out of the ordinary, however i've now began working on a new spreadsheet and have become stuck not long after beginning.

If anybody can help that would be greatly appreciated, however please do bear with me as i'm not quite the whizz on excel!

Problem / Issue

As you can see in column A, I have created a dropdown split between "supplier type" and at the moment this is a standalone dropdown and nothing more. I would like to be able to select an option from the aforementioned dropdown and for this to have the ability to change the dropdown choices in the next column and so on.

For example, if I choose material supplier, I would like only material suppliers to be shown in the dropdown in column B, and if I choose Plant Supplier in Column A then only plant suppliers will be shown in column b.

With that said, I'd like to follow on from there again so when I select a supplier in column B a separate dropdown option will be shown in column C, which will stay relative.


If that's not explained well enough, please let me know

Thanks

Picture1.png

see big yellow banner - upload your workbook
help us to help you as we do not want to spend time building an unrepresentative work sheet.