Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 17th 09, 07:48 PM posted to microsoft.public.excel.misc
Nat Nat is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 47
Default 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   Report Post  
Old August 17th 09, 08:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2,722
Default 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   Report Post  
Old August 17th 09, 10:01 PM posted to microsoft.public.excel.misc
Nat Nat is offline
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 47
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pulling data from other wb based on data to populate dropdown list Suzann Excel Discussion (Misc queries) 0 April 23rd 09 04:29 PM
Drop down list based on choice of another dropdown Amy Excel Discussion (Misc queries) 2 January 23rd 08 08:39 PM
Need to link dropdown box choice to another cell lrb Excel Discussion (Misc queries) 6 December 12th 07 08:08 PM
Multiple choice in dropdown list Augusta Excel Discussion (Misc queries) 1 October 19th 07 10:16 AM
Dropdown list/Multiple choice?? KDD Excel Discussion (Misc queries) 2 August 30th 05 09:28 AM


All times are GMT +1. The time now is 03:39 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017