Hi, i'm hoping someone can help me with this because i'm going around in circles! Only know the basics of excel so if you could dumb it down i'd really appreciate it.

I want to create a form to be filled out by our client with a series of 3 drop down lists each dependant on the previous, then a fourth column that autofills based on the 3 previous selections.

So column 1 would be offer a drop down list, column 2 would offer another drop down list based on what was selected in column1, column 3 would offer another drop down list based on what was selected in column 2 then column 4 would autofill based on those 3 selections.

Also after a way for the 2nd column to automatically show 'please select' after the first drop down list has been selected and the 3rd to do the same after the 2nd drop down list has been selected.

Additionally if its possible that at any time extra data can be added and automatically appear in the drop down lists without leaving a bunch of blank cells at the bottom.

I hope this makes sense - i've done spreadsheets before with some of the above but combining it all together is becoming a headache.

Thankyou in advance