list

[bonovox12]

Hi I want to create a list of data. I have being trying to use the list but it doesn’t do what I need to do. I want what ever I select to be in cell a2. Cell a 1 is the header.



ERU8
BE500 Index
BP0001M Index
BP0002M Index
BP0003M Index
BP0006M Index
BPCV1 CMPN

 

[BrianB]

Put the list in a range somewhere. Select cell A2 and use Data/Validation ...List