| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to get a 2nd dropbox based on results, entry of 1st dropbox
excel ver.5 I am trying to set up purchase list. The purchases need to be
id'd by a main group, a sub-group based on the main group selection & a 2nd sub-group based on the 1st sub-group selection. A drop down works great for the main group but I can't figure out how to make the next two work on the result/selection of the first one. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to get a 2nd dropbox based on results, entry of 1st dropbox
See Debra Dalgleish's excellent explanation of Dependent Lists:
http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "khwoz" wrote: excel ver.5 I am trying to set up purchase list. The purchases need to be id'd by a main group, a sub-group based on the main group selection & a 2nd sub-group based on the 1st sub-group selection. A drop down works great for the main group but I can't figure out how to make the next two work on the result/selection of the first one. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to get a 2nd dropbox based on results, entry of 1st dropbo
Thanks, that should work great. You guys are fast! I signed up after typing
my question. once I logged on, there were several answers same as yours. I guess what i'm saying is sorry for asking something already listed on the board. "Ron Coderre" wrote: See Debra Dalgleish's excellent explanation of Dependent Lists: http://www.contextures.com/xlDataVal02.html Does that help? *********** Regards, Ron XL2002, WinXP "khwoz" wrote: excel ver.5 I am trying to set up purchase list. The purchases need to be id'd by a main group, a sub-group based on the main group selection & a 2nd sub-group based on the 1st sub-group selection. A drop down works great for the main group but I can't figure out how to make the next two work on the result/selection of the first one. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Entry Formula based on IF or something Better | New Users to Excel | |||
| Delete Entry Based on Selection | Excel Discussion (Misc queries) | |||
| Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
| Formula based on a cell entry | Excel Discussion (Misc queries) | |||
| Prevent entry based on another cell value | Excel Worksheet Functions | |||
Hybrid Mode
