Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to create dropdowns in Excel
Hey,
I have a list of clients in Cells A1..A3. This list is ever changing and may go from three to thirty clients! Cells D1..E12 contain an ever-changing list of projects per client (Client Names in column D and Project Names in column E), thusly: Column D Column E ------------------------------- Client-1 Project-1 Client-1 Project-2 Client-2 Project-3 Client-2 Project-4 Client-3 Project-5 What I'd like to do is: A) display a dropdown-list of clients in Cell AA1 and then, B) display a dropdown-list of corresponding projects in Cell AB1 depending on the client selected in AA1. For A) I understand I can use Data--Validation and point it to a list For B) How do I program the dropdown to be dependent on what was selected? Is this something that can be done..programmatically or with a macro (note the list of clients and projects keep changing...almost on a bi-weekly basis). TIA, FxAS |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to create dropdowns in Excel
There are instructions here for creating dependent data validation lists
from a sorted master list: http://www.contextures.com/xlDataVal13.html FXAs wrote: Hey, I have a list of clients in Cells A1..A3. This list is ever changing and may go from three to thirty clients! Cells D1..E12 contain an ever-changing list of projects per client (Client Names in column D and Project Names in column E), thusly: Column D Column E ------------------------------- Client-1 Project-1 Client-1 Project-2 Client-2 Project-3 Client-2 Project-4 Client-3 Project-5 What I'd like to do is: A) display a dropdown-list of clients in Cell AA1 and then, B) display a dropdown-list of corresponding projects in Cell AB1 depending on the client selected in AA1. For A) I understand I can use Data--Validation and point it to a list For B) How do I program the dropdown to be dependent on what was selected? Is this something that can be done..programmatically or with a macro (note the list of clients and projects keep changing...almost on a bi-weekly basis). TIA, FxAS -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using dropdowns | Excel Discussion (Misc queries) | |||
Excel DropDowns | Excel Discussion (Misc queries) | |||
Newbie Lost with comboboxes and dropdowns in excel | Excel Discussion (Misc queries) | |||
DropDowns | Excel Discussion (Misc queries) | |||
Dropdowns | Excel Discussion (Misc queries) |