How to add dynamic contents in drop down list
Hi Team,
I would like my drop down list dynamic depending on contents of other column from other sheet.
Can you please help me to achieve that ?
Here in attached sheet I have 3 drop down lists , 1st one should have all the sheets names as list contents.
2nd drop down must have contents of B column from respective selected sheet.
Can you please help on this ?
Any help please ??
Perhaps this will help.
1. Produce a list of products based on the name in cell A6 using the formula: =IFERROR(INDEX(INDIRECT(A$6&"!B3:B20"),MATCH(0,INDEX(COUNTIF(S$3:S3,INDIRECT(A$6&"!B3:B20")),,),)),0)
Note that the list is shown in column S but may be moved and/or hidden for aesthetic purposes.
2. Set the source of the data validation in cell C6 to read: =OFFSET($S$4,0,0,SUMPRODUCT(--($S$4:$S$21<>0)))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks