Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to create what I would call a pull down selector list . This
botton would open a pull down list , that would have multiple row with data that is selected based on a standard set of data. This selected row in the list is then placed in the three cells on the worksheet For example : spreadsheet has a botton for cell G11 to I11 the data for this comes from a list outside the working area and the list would look like this: Row Colmun D E F 20 ma 4 20 21 volt 0.8 3.2 22 volt 1.0 5.0 (select one of the three options above) (the data would be placed in the three cells on the worksheet) To me this should have been a fairly common requirement and simple to actually setup. Can anyone tell me if this is possible and if so just how I would do it. Thanks old fellow |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing mult drop down list | Excel Worksheet Functions | |||
How do you use a dropdown menu to enter data in mult. cells exce? | Excel Worksheet Functions | |||
Problem protecting cells in a mult-page workbook | Excel Discussion (Misc queries) | |||
adding two colmuns together | Excel Discussion (Misc queries) | |||
Excel contact list-going from one row to mult. columns | Excel Discussion (Misc queries) |