group a data drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-1405818%22%20slang%3D%22en-US%22%3Egroup%20a%20data%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1405818%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20a%20long%20list%20of%20account%20codes%20that%20i%20would%20like%20to%20include%20in%20a%20drop%20down%20list.%26nbsp%3B%20these%20codes%20are%20grouped%20by%20category%20-%20i.e.%20Salaries%20%26amp%3B%20Benefits%2C%20Supplies%2C%20etc%3C%2FP%3E%3CP%3Eis%20it%20possible%26nbsp%3B%20to%20make%20a%20drop%20down%20list%20with%20the%20categories%20which%20could%20be%20expanded%20to%20the%20detail%20accounts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethank%20you%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1405818%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1406992%22%20slang%3D%22en-US%22%3ERe%3A%20group%20a%20data%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1406992%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F671853%22%20target%3D%22_blank%22%3E%40BethBeth101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20this%20is%20what%20you're%20getting%20at.%20I%20have%20created%20here%20a%20group%20of%20%22Primary%22%20entry%20cells%2C%20each%20of%20which%20refers%20to%20a%20list%20of%20valid%20entries%20over%20in%20Column%20B%3B%20then%20a%20set%20of%20%22Secondary%22%20entries%20that%20are%20directed%2C%20by%20means%20of%20an%20INDIRECT%20in%20the%20Data%20Validation%20window%2C%20to%20drop%20downs%20appropriate%20for%20Salary%20%26amp%3B%20Benefits%2C%20or%20Supplies%2C%20or%20%22Etc%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20makes%20use%20of%20%3CU%3Enamed%20ranges%3C%2FU%3E%20for%20the%20secondary%20entry%20validations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20essentially%20it's%20a%20primary%20menu%2C%20followed%20by%20tailored%20secondary%20menus.%20It's%20also%20possible%2C%20with%20the%20new%20Dynamic%20Array%20functions%2C%20to%20make%20something%20like%20this%2C%20well%2C%20%22dynamic%2C%22%20meaning%20you%20could%20be%20adding%20new%20options%20in%20a%20real-time%20basis.%20I'm%20assuming%20for%20now%20that%20this%20method%20would%20suffice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20misunderstood%20your%20request%2C%20perhaps%20you%20could%20come%20back%20with%20a%20more%20detailed%20description%20with%20more%20examples.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

i have a long list of account codes that i would like to include in a drop down list.  these codes are grouped by category - i.e. Salaries & Benefits, Supplies, etc

is it possible  to make a drop down list with the categories which could be expanded to the detail accounts?

 

thank you for your help

1 Reply

@BethBeth101 

 

I think this is what you're getting at. I have created here a group of "Primary" entry cells, each of which refers to a list of valid entries over in Column B; then a set of "Secondary" entries that are directed, by means of an INDIRECT in the Data Validation window, to drop downs appropriate for Salary & Benefits, or Supplies, or "Etc"

 

This makes use of named ranges for the secondary entry validations.

 

So essentially it's a primary menu, followed by tailored secondary menus. It's also possible, with the new Dynamic Array functions, to make something like this, well, "dynamic," meaning you could be adding new options in a real-time basis. I'm assuming for now that this method would suffice.

 

If I misunderstood your request, perhaps you could come back with a more detailed description with more examples.