Looking for Help to Auto Refresh - Data Validation "List".
I have Master sheet in which 2 Columns like 1. Category and 2. Field Name. ("Master "data)
Table 1:
<tbody>
</tbody>
I have another tab ("Client to Fill") which has more columns and the requirement is listed below:
It has Category, Field Name, Data
1. The Category has DEP-ACCT, TIME-DEP and DEP-TXN (i can use Data Validation - List and restrict to use these 3 values)
2. Field Name, we need to bring it from Master Data and we need to use Data Validation - List again.
But Limit the Fields Names to be shown in drop down with associated Category.
Similarly, The client will keep adding Field Names randomly against the 3 categories.
So this Field Name drop down list should show the category and respective Field Names to them "automatically" by including new / additional fields.
Like this: ("Client to Fill "sheet looks)
<tbody>
</tbody>
I can not ask my client to use PQ or VBA. Please share any formula as of Excel 2010 version. thank you.
I have Master sheet in which 2 Columns like 1. Category and 2. Field Name. ("Master "data)
Table 1:
Category | Field Name | Updated |
DEP-ACCT | D1 | 05-Jan |
DEP-ACCT | D2 | 05-Jan |
DEP-ACCT | D3 | 05-Jan |
TIME-DEP | T1 | 05-Jan |
TIME-DEP | T2 | 05-Jan |
TIME-DEP | T3 | 05-Jan |
DEP-TXN | X1 | 05-Jan |
DEP-TXN | X2 | 05-Jan |
DEP-ACCT | D4 | 09-Jan |
DEP-TXN | X3 | 12-Jan |
<tbody>
</tbody>
I have another tab ("Client to Fill") which has more columns and the requirement is listed below:
It has Category, Field Name, Data
1. The Category has DEP-ACCT, TIME-DEP and DEP-TXN (i can use Data Validation - List and restrict to use these 3 values)
2. Field Name, we need to bring it from Master Data and we need to use Data Validation - List again.
But Limit the Fields Names to be shown in drop down with associated Category.
Similarly, The client will keep adding Field Names randomly against the 3 categories.
So this Field Name drop down list should show the category and respective Field Names to them "automatically" by including new / additional fields.
Like this: ("Client to Fill "sheet looks)
Category | Field Name | Data to Fill |
DEP-ACCT | List down and choose one field (D1,D2, D3, D4) | Abc.. |
TIME-DEP | List down and choose one field (T1,T2, T3, T4) | XyZ.. |
TIME-DEP | List down and choose one field (T1,T2, T3, T4) | N1234.. |
TIME-DEP | List down and choose one field (T1,T2, T3, T4) | Vtq.. |
DEP-TXN | List down and choose one field (X1,X2, X3) | Npqwe.. |
DEP-TXN | List down and choose one field (X1,X2, X3) | Fill.. |
TIME-DEP | List down and choose one field (T1,T2, T3, T4) | Fill.. |
DEP-ACCT | List down and choose one field (D1,D2, D3, D4) | Fill.. |
This list to reflect data from master sheet and lists field names from specific Category |
<tbody>
</tbody>
I can not ask my client to use PQ or VBA. Please share any formula as of Excel 2010 version. thank you.