Lists obtaining additional information

[engmgriff]

Hi

I have created a dynamic list. From this list I would like (dependin
on what the user has chosen) another list which represents the lis
they have chosen to be entered into a column on the worksheet.

Example

If a user had to choose in there first list if they wanted fruit o
veg. The second list depending on what they choose they could the
choose there veg or fruit. (I have done this). My problem is now tha
once they have picked what they want I would like certain cells t
contain say supplier, telephone No, Address which refers to the frui
or veg they want. I have this info in a table already but want i
transfering over depending on what they choose. Therefore they can se
the fruit, type of fruit (only one choise, supplier, telephone number
adrees). There could be a number of different suppliers for on
particular fruit, which I need to show.

Thanks

Mat

 

[JE McGimpsey]

See Debra Dalgleish's article:

http://contextures.com/xlDataVal02.html