Excel 2010 drop down selection

[sallan]

Hi Again


Can any one help? I do not want to use VB.


I need to achieve the following:


Select a drop down in one column puts a value in the next cell over.


Well below average, barely meets minimum requirements. 1

Slightly below average, meets minimum requirements. 2

Average, meets minimum requirements, exceeds minimum requirements in some areas. 3

Above average, exceeds minimum requirements in many or all areas. 4

Outstanding, far exceeds minimum requirements in most areas. 5


Thanks


sam

 

[dan_l]

Probably the easiest is to arrange your data into a table with all of those values calculated out. Use data validation or a drop down box to 'choose' which result is delayed.

 

[sallan]

Hi


Got that, can manage the one drop down but not the insert of a number in the next column cell.


Also text in select box is too small

 

[SirJB7]

Hi, sallan!


If I don't understand you wrongly you shouldn't use data validation (as data validation only validates data entered in current cell but doesn't change any other cell value, unless those referred by formulas) but a drop down list box control which both have a property called Link Cell where you can define the "insert" (I'd say fill or set) of a related value.


You have 2 options for these, form controls (not updated for more than 10 years but still available for using) and ActiveX controls (newer and more user friendly, specially for property handling).


Any of those methods is suitable if you have to insert only one or just a few values, that's to say, they're not practical for use on every row, since you have to assign manually the Linked Cell to each one. If this were the case you should opt for data validation against a list in a column, a table that associates the values of that list to the inserted values, and another column with a formula that makes the link between the value selected from the list and the value wanted to be inserted.


Hope it helps.


Regards!