It can be done through Validation. Debra Dalgleish has
examples of how to do this on her website:

http://www.contextures.com/xlDataVal02.html

HTH
Jason
Atlanta, GA

-----Original Message-----
For example, if I have an option of putting a-z in cell
A1... in cell B1, I
want to pull a list that is specialized based on the
information in A1 (A
List, B List, etc). How is this done, if possible?

Regards,
Braden
.