Data Validation List help

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)

Business AreaFinancial YearBudget Name
118/19General
118/19Extended
119/20General
119/20Extended
218/19General
219/20General
318/19General
320/21General
321/22General

<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:

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,099,144
Messages
5,466,934
Members
406,511
Latest member
markflayd

This Week's Hot Topics

Top