wrightyrx7
Well-known Member
- Joined
- Sep 15, 2011
- Messages
- 994
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)
<tbody>
</tbody>
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.
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)
Business Area | Financial Year | Budget Name |
1 | 18/19 | General |
1 | 18/19 | Extended |
1 | 19/20 | General |
1 | 19/20 | Extended |
2 | 18/19 | General |
2 | 19/20 | General |
3 | 18/19 | General |
3 | 20/21 | General |
3 | 21/22 | General |
<tbody>
</tbody>
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.
Last edited: