Cathmac801
New Member
- Joined
- Apr 23, 2014
- Messages
- 20
Hi Folks, I am working on a spreadsheet that has 2 tabs "Master sheet" "Rule type"
On the Rule Type sheet there is a column called 'Location' (this is a number and the same number can show up multiple times), there is also a column called 'Rule Type' - for each location there are multiple rule types (this sheet has c1500 rows)
On the Master sheet there are multiple columns, one is called 'Location' and another is called 'rule type' - i want to set up the 'rule type' cell so that when you click on it only the rule type options for the specific location are available (i.e. a drop down list).
I have seen some examples on my research but can't seem to find exactly what i'm looking for, any help much appreciated.
This is an example of the 'Rule Type' sheet
On the Rule Type sheet there is a column called 'Location' (this is a number and the same number can show up multiple times), there is also a column called 'Rule Type' - for each location there are multiple rule types (this sheet has c1500 rows)
On the Master sheet there are multiple columns, one is called 'Location' and another is called 'rule type' - i want to set up the 'rule type' cell so that when you click on it only the rule type options for the specific location are available (i.e. a drop down list).
I have seen some examples on my research but can't seem to find exactly what i'm looking for, any help much appreciated.
This is an example of the 'Rule Type' sheet
Location | Rule Type |
1 | XRJ-111 |
1 | RZ2-156 |
1 | 3% annually |
7 | XTP-876 |
7 | 3% annually |
954 | WEQ-456 |