Dynamic Dependent "Data Validation" - List

[ManiThani]

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:
[TABLE="width: 430"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Field Name[/TD]
[TD]Updated[/TD]
[/TR]
[TR]
[TD]DEP-ACCT[/TD]
[TD]D1[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]DEP-ACCT[/TD]
[TD]D2[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]DEP-ACCT[/TD]
[TD]D3[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]TIME-DEP[/TD]
[TD]T1[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]TIME-DEP[/TD]
[TD]T2[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]TIME-DEP[/TD]
[TD]T3[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]DEP-TXN[/TD]
[TD]X1[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]DEP-TXN[/TD]
[TD]X2[/TD]
[TD="align: right"]05-Jan[/TD]
[/TR]
[TR]
[TD]DEP-ACCT[/TD]
[TD]D4[/TD]
[TD="align: right"]09-Jan[/TD]
[/TR]
[TR]
[TD]DEP-TXN[/TD]
[TD]X3[/TD]
[TD="align: right"]12-Jan[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

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)
[TABLE="width: 657"]
<tbody>[TR]
[TD]Category[/TD]
[TD]Field Name[/TD]
[TD]Data to Fill[/TD]
[/TR]
[TR]
[TD]DEP-ACCT[/TD]
[TD]List down and choose one field (D1,D2, D3, D4)[/TD]
[TD]Abc..[/TD]
[/TR]
[TR]
[TD]TIME-DEP[/TD]
[TD]List down and choose one field (T1,T2, T3, T4)[/TD]
[TD]XyZ..[/TD]
[/TR]
[TR]
[TD]TIME-DEP[/TD]
[TD]List down and choose one field (T1,T2, T3, T4)[/TD]
[TD]N1234..[/TD]
[/TR]
[TR]
[TD]TIME-DEP[/TD]
[TD]List down and choose one field (T1,T2, T3, T4)[/TD]
[TD]Vtq..[/TD]
[/TR]
[TR]
[TD]DEP-TXN[/TD]
[TD]List down and choose one field (X1,X2, X3)[/TD]
[TD]Npqwe..[/TD]
[/TR]
[TR]
[TD]DEP-TXN[/TD]
[TD]List down and choose one field (X1,X2, X3)[/TD]
[TD]Fill..[/TD]
[/TR]
[TR]
[TD]TIME-DEP[/TD]
[TD]List down and choose one field (T1,T2, T3, T4)[/TD]
[TD]Fill..[/TD]
[/TR]
[TR]
[TD]DEP-ACCT[/TD]
[TD]List down and choose one field (D1,D2, D3, D4)[/TD]
[TD]Fill..[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]This list to reflect data from master sheet and lists field names from specific Category[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I can not ask my client to use PQ or VBA. Please share any formula as of Excel 2010 version. thank you.

 

[Joe4]

Welcome to the Board!

We see that this question has been cross-posted here: Dynamic Dependent "Data Validation"

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[ManiThani]

I registered yesterday in the forum and submitted my query. I was not aware of the rules.

Do I need to delete here my query from here ?

Excel Help Forum

 

[Joe4]

I registered yesterday in the forum and submitted my query. I was not aware of the rules.

Do I need to delete here my query from here ?

No, you do not need to delete your question here. As I said, we allow you to Cross-Post, but you just must mention that you are doing so and post a link to the other threads you started on other forums. That way no one waste their time or duplicates efforts suggesting answers that might have already been suggested elsewhere.

The link I posted in the previous post contains all our rules.