Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate one column based on the dropdown choice of others
Here is the situation. My friend sent me a spreadsheet in 03 format. He has
3 columns which are affected : REASON, SOURCE and DEPARTMENT. The REASON column has 11 choices. If the user chooses 3 of those choices ("new", "refund", or "service" he would like the SOURCE column to have the following choices: TA, Direct Guest, but if the user selects any of the other 8 choices in REASON column, he would like the SOURCE column to have the following choices: "TA", "Direct Guest", "Internal". If the user sees the 3 choices in the SOURCE column and selects "Internal", then he would like for there to be a drop down in the DEPARTMENT column. He has named the lists as follows Srce1(2 choices) or Srce2 (3choices) and Dept. I saw an earlier post where someone did an IF(A2="New",Srce1) but i kept getting errors when trying to add additional choices to "New" Is there possibly a better way to accomplish this task? Thanks a lot |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate one column based on the dropdown choice of others
Check out this site for creating dependent lists:
http://www.contextures.com/xldataval02.html It's got several examples which are pretty easy to follow, and as they say, a picture is worth a thousand words! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Nat" wrote: Here is the situation. My friend sent me a spreadsheet in 03 format. He has 3 columns which are affected : REASON, SOURCE and DEPARTMENT. The REASON column has 11 choices. If the user chooses 3 of those choices ("new", "refund", or "service" he would like the SOURCE column to have the following choices: TA, Direct Guest, but if the user selects any of the other 8 choices in REASON column, he would like the SOURCE column to have the following choices: "TA", "Direct Guest", "Internal". If the user sees the 3 choices in the SOURCE column and selects "Internal", then he would like for there to be a drop down in the DEPARTMENT column. He has named the lists as follows Srce1(2 choices) or Srce2 (3choices) and Dept. I saw an earlier post where someone did an IF(A2="New",Srce1) but i kept getting errors when trying to add additional choices to "New" Is there possibly a better way to accomplish this task? Thanks a lot |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate one column based on the dropdown choice of others
Thanks I can definitely use the dependent lists for the 1st part of this. In
the DEPARTMENT column, it would be nice if there is only a drop down choice if a specific choice is selected. If I use the Indirect method, it still lists a drop down arrow, it just will not allow you put something in that column. It is functionally correct but a little misleading. Right now if they choose "Internal" it gives them a drop down with choices. If they chose something else, they still see the drop down arrow but just cannot enter anything. Thanks again. I am definitely on the correct path. "Luke M" wrote: Check out this site for creating dependent lists: http://www.contextures.com/xldataval02.html It's got several examples which are pretty easy to follow, and as they say, a picture is worth a thousand words! -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Nat" wrote: Here is the situation. My friend sent me a spreadsheet in 03 format. He has 3 columns which are affected : REASON, SOURCE and DEPARTMENT. The REASON column has 11 choices. If the user chooses 3 of those choices ("new", "refund", or "service" he would like the SOURCE column to have the following choices: TA, Direct Guest, but if the user selects any of the other 8 choices in REASON column, he would like the SOURCE column to have the following choices: "TA", "Direct Guest", "Internal". If the user sees the 3 choices in the SOURCE column and selects "Internal", then he would like for there to be a drop down in the DEPARTMENT column. He has named the lists as follows Srce1(2 choices) or Srce2 (3choices) and Dept. I saw an earlier post where someone did an IF(A2="New",Srce1) but i kept getting errors when trying to add additional choices to "New" Is there possibly a better way to accomplish this task? Thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data from other wb based on data to populate dropdown list | Excel Discussion (Misc queries) | |||
Drop down list based on choice of another dropdown | Excel Discussion (Misc queries) | |||
Need to link dropdown box choice to another cell | Excel Discussion (Misc queries) | |||
Multiple choice in dropdown list | Excel Discussion (Misc queries) | |||
Dropdown list/Multiple choice?? | Excel Discussion (Misc queries) |