Dynamic Dependent "Data Validation" - List

ManiThani

New Member
Joined
Jan 20, 2017
Messages
9
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:
CategoryField NameUpdated
DEP-ACCTD105-Jan
DEP-ACCTD205-Jan
DEP-ACCTD305-Jan
TIME-DEPT105-Jan
TIME-DEPT205-Jan
TIME-DEPT305-Jan
DEP-TXNX105-Jan
DEP-TXNX205-Jan
DEP-ACCTD409-Jan
DEP-TXNX312-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)
CategoryField NameData to Fill
DEP-ACCTList down and choose one field (D1,D2, D3, D4)Abc..
TIME-DEPList down and choose one field (T1,T2, T3, T4)XyZ..
TIME-DEPList down and choose one field (T1,T2, T3, T4)N1234..
TIME-DEPList down and choose one field (T1,T2, T3, T4)Vtq..
DEP-TXNList down and choose one field (X1,X2, X3)Npqwe..
DEP-TXNList down and choose one field (X1,X2, X3)Fill..
TIME-DEPList down and choose one field (T1,T2, T3, T4)Fill..
DEP-ACCTList 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.

 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,975
Office Version
  1. 365
Platform
  1. Windows
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.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,975
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,514
Messages
5,602,091
Members
414,501
Latest member
mdhaumyu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top