• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

i need to create an excel drop down list that that is limited

i need to create an excel drop down list that that is limited by another column.

 for example, the drop down list would be created from column 2 where column 5 has a value of "RA" but not include entries from column 2 that correspond to a different value in column 5
0
mmarth
Asked:
mmarth
  • 4
  • 3
1 Solution
 
Roy CoxGroup Finance ManagerCommented:
This can be done but you need to attach an example workbook that shows where the values are stored and what they are. Here's an example that I made for someone else that might help you.
Dependant_DV.xls
0
 
mmarthAuthor Commented:
what i am needing is on sheet 2 of Dependant_DV2 F2 : F6 except i only want customers where column c='as'
Dependant_DV2.xls
0
 
Roy CoxGroup Finance ManagerCommented:
If you look at the example in Sheet 3 you will see three lists. Each Column is named according to the header. So in sheet1 when Customer 1 is selected, the options in the second combobox the choices are from that column, using the INDIRECT Function to select that list.

You need to make si9milar lists. If you provide the lists to choose from then I'll help you apply the method.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
mmarthAuthor Commented:
what i am trying to do is not so involved. on the attached file WorkbookTest i want the drop down boxes on sheet 2 to bring in choices from sheet Lots like i have done except only when the variety is the same as sheet2!$A$1  such as '14RD62'.  i want to limit the choices to this variety.
0
 
mmarthAuthor Commented:
WorkbookTest
WorkbookTest.xlsx
0
 
Roy CoxGroup Finance ManagerCommented:
I missed the final reply. If I understand correctly then this will be best with AdvancedFilter, automated with VBA. See attached example
WorkbookTest.xlsm
0
 
mmarthAuthor Commented:
appreciate this solution. just wish it was automated and did not need to run the macro when changes were made to the table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now