limit cell list selection based on the selection of another list
 

I want to create a list in excel that will automatically limit the user's
selection based on their selction in a previous cell. I know some VBA and can
crete a macro if I need to. Your advice is appreciated.

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

--
Regards
Frank Kabel
Frankfurt, Germany

lorraine wrote:
I want to create a list in excel that will automatically limit the
user's selection based on their selction in a previous cell. I know
some VBA and can crete a macro if I need to. Your advice is
appreciated.

If your lists are generated with Validation, check out:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to create a list in excel that will automatically
limit the user's
selection based on their selction in a previous cell. I
know some VBA and can
crete a macro if I need to. Your advice is appreciated.
.