View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xami
 
Posts: n/a
Default Data validation problem


Hello,

at first place I would like to say I donīt have very good skill in
excel, so if my question is stupid, please be kind on me ;)

I need to create some function or anything else. Iīve one cell in which
is data validation based on list (app. 5 items). Determinate on which
item of list is selected, in next cell I need to choose from another
list of items.

For example:
in first list there are items: error1,error2,....,error5.
next lists a error1A,error1B,.....,error1X
error2A,error2B,......
and so on.

so if i choose error 1 - in next cell I can choose only from
error1A....error1X..
so please if you know any solution, or something that could help me, i
would by very happy...

thx


--
xami
------------------------------------------------------------------------
xami's Profile: http://www.excelforum.com/member.php...o&userid=32180
View this thread: http://www.excelforum.com/showthread...hreadid=519262