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

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

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

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