Hello All,

Hopefully this is an easy one but I can't find an explanation anywhere on the net.

The easiest way to explain this is with an example.

On my input worksheet I have these headings:
A1 - Main Category

B1 - Cost Centre

C1 - Sub-Category


On my lists sheet I have:

Main Category
Column A
A1 - Education
A2 - Farming
Etc.

Cost Centre
Column B - Education
B1 - School 1
B2 - School 2
Etc.

Column C - Farming
C1 - Farm 1
C2 - Farm 2
Etc

Sub-Category (This is where it starts to get tricky)

Column D - Education
E1 - Books
E2 - Paper
Etc

Column E - Farming
D1 - Clearing
D2 - Planting
Etc


So ideally the sub-category data validation list would be driven by "Farming" or "Education" as selected in "Main Category" on the input page. However, the named ranges "Farming" and "Education" have already been used to drive cost centre.

The problem is that all the farms share the same sub-categories, as do the schools.

Any advice on how to make it work properly would be much appreciated.