View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
old fellow old fellow is offline
external usenet poster
 
Posts: 1
Default create a list that places data in 3 colmuns (cells) from mult row/

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