Complex Excell Template Fix
Budget: $20 – $30 NZD
This is not an easy fix - Advance Knowledge is required.
Problem: Column E
The droplist in column E is dependent on the library in column S
The Industry sector in column F is dependent on the library in column U
Colum T apparently was only created to group the Industry sector based on the Business Area
the formula should basically minimise the selection errors; when someone selects the "Agriculture, hunting and related service activities" business area in the Industry sector area, only those activities related to this business sector will be available for selection.
All the sheets are similar, so a copy-paste would sort out the others once one is fixed.
Problem: Column E
The droplist in column E is dependent on the library in column S
The Industry sector in column F is dependent on the library in column U
Colum T apparently was only created to group the Industry sector based on the Business Area
the formula should basically minimise the selection errors; when someone selects the "Agriculture, hunting and related service activities" business area in the Industry sector area, only those activities related to this business sector will be available for selection.
All the sheets are similar, so a copy-paste would sort out the others once one is fixed.