Data Validation List help

[wrightyrx7]

Hi all,

I have a table with to Data Validation drop down lists.

Business Area
Financial Year
Budget Name

I need to create some sort of cascading drop down list from this table (data is added to this table all the time)

[TABLE="width: 414"]
<tbody>[TR]
[TD="width: 138"]Business Area[/TD]
[TD="width: 138"]Financial Year[/TD]
[TD="width: 138"]Budget Name[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD]18/19[/TD]
[TD]General[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD]18/19[/TD]
[TD]Extended[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD]19/20[/TD]
[TD]General[/TD]
[/TR]
[TR]
[TD="class: xl65"]1[/TD]
[TD]19/20[/TD]
[TD]Extended[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD]18/19[/TD]
[TD]General[/TD]
[/TR]
[TR]
[TD="class: xl65"]2[/TD]
[TD]19/20[/TD]
[TD]General[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD]18/19[/TD]
[TD]General[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD]20/21[/TD]
[TD]General[/TD]
[/TR]
[TR]
[TD="class: xl65"]3[/TD]
[TD]21/22[/TD]
[TD]General[/TD]
[/TR]
</tbody>[/TABLE]


So if someone selected Business area "1", the next list would only contain "18/19 & 19/20", then if they select 18/19 the next list would only contain "General & Extended".

I can use VBA or if there is a way with by Defining some named ranges i could do that to. I just need a bit of guidance.

 

[AlanY]

you need a dynamic drop down list, have a look of this

https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/

 

[wrightyrx7]

you need a dynamic drop down list, have a look of this

https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/

I will look into this, thanks AlanY

 

[wrightyrx7]

you need a dynamic drop down list, have a look of this

https://www.ablebits.com/office-addins-blog/2014/09/30/dependent-cascading-dropdown-lists-excel/

Been trying all day, still cant figure it out :'(

 

[MickG]

Try this:-
You need to fill a Validation list in column "A" prior to running the code, i.e. 1,2,3
https://app.box.com/s/rpmms8tsfotsv16twrenn4enr7sgm0gd

 

[wrightyrx7]

Try this:-
You need to fill a Validation list in column "A" prior to running the code, i.e. 1,2,3
https://app.box.com/s/rpmms8tsfotsv16twrenn4enr7sgm0gd

PERFECT!!! Thank you so much MickG

 

[MickG]

Try this , It's a bit better , loads "A2" validation list and Data now has Headers .
https://app.box.com/s/1fte2temwmlh6lvytnh6jwdg3eo9c3dd