Cascading Data Validated Dropdown Lists or Tables - help!!

Hello team,

I'm a newbie at the more complicated formulas and functions of Excel. I hope I can explain what I'm after.

So I have a table of data which Column B contains a selection. When you select one of these options in Coumn B..Column C needs to reflect what matches the selection. Then when Column C is selected, Column D needs to refelct what options Column C alows.

I'm also curious if there is a way to add a "+" button that can copy and insert a row underneath an existing row without having to right click copy, insert row, and paste. I want to make the user not worry about too many clicks etc. I'm not even sure that it is possible.

I've atttached my file with my display tabe and my data tab.

Thanks heaps if you can help.

Regards

Adam (Flightless Kiwi)

Simple Userform with cascading comboboxes - self maintaining - there are no on-sheet formula to corrupt or expand.
Simple VBA/macro driven - 3 click choices + save.
Please, please do not use merged cells when data handling - they should never have been invented - designed by MS to bite the bum of the unwary.

Try the attached - the sheet has a 'proper table' from row 2 down
to expand the table just make your first entry in column 'A' in the first vacant row under the table.
This is the beauty of 'proper tables' all your formula & data validation will dynamically expand with the table expansion.
After the first step you can then select the 'hazard' entries and they will populate the new row.

It can be difficult to recommend tutorial matter as we all have different levels of knowledge intake.
I have been programming for over fifty years using many differing platforms and still have difficulty taking in certain methods especially those presented on 'YouTube'
My preference is by 'Google' search - I find most queries can be answered if you construct your question logically.
Developing an address book is a good starting point - first do some reading (on Google) use of tables - then label your headers (firstname,lastname,address etc., etc.,)
then open up the VB editor and insert a userform - on to this place a label and textbox for each column - then four command buttons - Clear,Add,Update,Delete.
These will cover the basics of an elementary pseudo database. On the attached there should be enough sample code to help you along.
To overcome begineers pitfalls - always start your code - first line - 'Option Explicit' - this forces you to declare (Dim) your variables and will help highlight errors when debugging - debug at every stage this stops you having a mass of errors to troubleshoot at the end - simple syntax errors are sometimes the most frustrating - such as a missing full stop or comma - it is like opening 'Pandora's Box' the more you practice and read the more you will learn and develop.
Happy coding