Argh! This is doing my head in today, should be straight forward :-(
I am creating a spreadsheet to track designers commissions. First column is the designers name, easy enough as a drop list. Then, the next section needs to show that particular designers work so I can track which design has sold. So, another drop down but this time it has to be dependant upon the name of the designer I choose.
I found several tutorials, followed through no problem but when I try to work with my own data something is going wrong.
https://trumpexcel.com/dependent-dro...list-in-excel/
https://exceljet.net/dependent-dropdown-lists
These are 2 tutorials which I'm following. Issue I have is when I define the =INDIRECT list. Always comes up with an error.
Could anyone show me a quick sheet where this works please? Or maybe tell me where I'm going wrong.