View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default insert a drop down list if a certain cell value is true

See if Debra Dalgleish's website helps:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"kd" wrote:

I use Windows XP.

What I need to acheive is, when a value is selected from a drop down list,
to return another dropdown list which matches the criteria, Ex. 1st list has
2 options, A&B and if A is selected return dropdown list which is related to
A. Hope this explains...