If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lists obtaining additional information
Hi
I have created a dynamic list. From this list I would like (depending on what the user has chosen) another list which represents the list 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 or veg. The second list depending on what they choose they could then choose there veg or fruit. (I have done this). My problem is now that once they have picked what they want I would like certain cells to contain say supplier, telephone No, Address which refers to the fruit or veg they want. I have this info in a table already but want it transfering over depending on what they choose. Therefore they can see the fruit, type of fruit (only one choise, supplier, telephone number, adrees). There could be a number of different suppliers for one particular fruit, which I need to show. Thanks Matt --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Lists obtaining additional information
See Debra Dalgleish's article:
http://contextures.com/xlDataVal02.html In article , engmgriff wrote: I have created a dynamic list. From this list I would like (depending on what the user has chosen) another list which represents the list 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 or veg. The second list depending on what they choose they could then choose there veg or fruit. (I have done this). My problem is now that once they have picked what they want I would like certain cells to contain say supplier, telephone No, Address which refers to the fruit or veg they want. I have this info in a table already but want it transfering over depending on what they choose. Therefore they can see the fruit, type of fruit (only one choise, supplier, telephone number, adrees). There could be a number of different suppliers for one particular fruit, which I need to show. |
Thread Tools | |
Display Modes | |
|
|