Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate a Validation List
I know how to take a cell and limit the input via a list using Data
Validation. Is there a way to populate that list using a range from another worksheet? Thanks, Les |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate a Validation List
Assign a name to the list, and just enter that name in the "Source" box.
=List_Name -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "WLMPilot" wrote in message ... I know how to take a cell and limit the input via a list using Data Validation. Is there a way to populate that list using a range from another worksheet? Thanks, Les |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate a Validation List
Thanks!! That worked great!
Add at twist to my original question. I am using this feature to make available airport identifiers. Every airport has a 3-letter identifier. So, if I enter AND as my departure airport (Cell B10), I don't want AND to appear in the drop down list for destination airport (B11). Not sure if this is possible via the validation list, but asking anyway. Is there a way to drop the airport that I depart from the list that will be used to pick the destination airport? Thanks, Les "RagDyer" wrote: Assign a name to the list, and just enter that name in the "Source" box. =List_Name -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "WLMPilot" wrote in message ... I know how to take a cell and limit the input via a list using Data Validation. Is there a way to populate that list using a range from another worksheet? Thanks, Les |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate a Validation List
Debra Dalgleish has a very extensive collection of web pages dedicated to
drop-downs. On one of these, she exhibits formulas and techniques of Peo Sjoblom for eliminating previously chosen items from the list. Check out: http://www.contextures.com/xlDataVal03.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "WLMPilot" wrote in message ... Thanks!! That worked great! Add at twist to my original question. I am using this feature to make available airport identifiers. Every airport has a 3-letter identifier. So, if I enter AND as my departure airport (Cell B10), I don't want AND to appear in the drop down list for destination airport (B11). Not sure if this is possible via the validation list, but asking anyway. Is there a way to drop the airport that I depart from the list that will be used to pick the destination airport? Thanks, Les "RagDyer" wrote: Assign a name to the list, and just enter that name in the "Source" box. =List_Name -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "WLMPilot" wrote in message ... I know how to take a cell and limit the input via a list using Data Validation. Is there a way to populate that list using a range from another worksheet? Thanks, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to populate part of a list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
Populate List Box | Excel Worksheet Functions | |||
Populate List / Combo Box | Excel Discussion (Misc queries) | |||
Populate Drop Down List | Excel Worksheet Functions |