View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Lists referencing lists...is it possible?

Try using Data Validation with Dependent Lists:

Debra Dalgleish's website shows you how:
http://www.contextures.com/xlDataVal02.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"JohnB" wrote:

I am looking to create two different lists for users to chose from. However,
I would like the second list to be dependent upon the item selected in the
first list. Is this possible?