| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What If and Drop Down List
Please advise on what the best strategy is for this situation:
Column A is Sales Type, Column B is Client Name If select "New Order" in Column A, I type a new client name. If select "Renewal Order", I want to see a list of existing clients. The purpose is to avoid any typos so that I can use code to munipulate the data. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What If and Drop Down List
Look at Data=Validation
Debra Dalgleish http://www.contextures.com/tiptech.html -- Regards, Tom Ogilvy "Curious" wrote: Please advise on what the best strategy is for this situation: Column A is Sales Type, Column B is Client Name If select "New Order" in Column A, I type a new client name. If select "Renewal Order", I want to see a list of existing clients. The purpose is to avoid any typos so that I can use code to munipulate the data. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What If and Drop Down List
Can the data validation in column B be on or off depending on the entry
in column A? On Jan 26, 2:21 pm, Tom Ogilvy wrote: Look at Data=Validation Debra Dalgleishhttp://www.contextures.com/tiptech.html -- Regards, Tom Ogilvy "Curious" wrote: Please advise on what the best strategy is for this situation: Column A is Sales Type, Column B is Client Name If select "New Order" in Column A, I type a new client name. If select "Renewal Order", I want to see a list of existing clients. The purpose is to avoid any typos so that I can use code to munipulate the data. Thanks in advance.- Hide quoted text -- Show quoted text - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What If and Drop Down List
Yes, that is true. The site Tom O suggests will show you how to do
Dependent Drop Downs. HTH Regards, Howard "Curious" wrote in message ps.com... Please advise on what the best strategy is for this situation: Column A is Sales Type, Column B is Client Name If select "New Order" in Column A, I type a new client name. If select "Renewal Order", I want to see a list of existing clients. The purpose is to avoid any typos so that I can use code to munipulate the data. Thanks in advance. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
What If and Drop Down List
If you combine it with a macro. Use the change event to determine whether
the data validation should be there or not. -- Regards, Tom Ogilvy "Curious" wrote in message oups.com... Can the data validation in column B be on or off depending on the entry in column A? On Jan 26, 2:21 pm, Tom Ogilvy wrote: Look at Data=Validation Debra Dalgleishhttp://www.contextures.com/tiptech.html -- Regards, Tom Ogilvy "Curious" wrote: Please advise on what the best strategy is for this situation: Column A is Sales Type, Column B is Client Name If select "New Order" in Column A, I type a new client name. If select "Renewal Order", I want to see a list of existing clients. The purpose is to avoid any typos so that I can use code to munipulate the data. Thanks in advance.- Hide quoted text -- Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list based on other drop down list pick | Excel Discussion (Misc queries) | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
![Curious[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
