drop down list and manual over ride

[swfarm]

hi guys

is it possible to have a drop down box linked with a cell BUT also be able to be used independently and retain the cell reference ?

so drop down box is in cell CD37 and its linked to CH21
however i need to be able to manually use CD37 but still retain the link to CH21

not sure if this is possible?
all help greatfully received

I know you will say just change CH21 to suit but i need to keep it as a reference

[Pete_UK]

Use another cell for your manual input, and then a simple IF statement can check if that cell is empty, and return your drop-down value instead.

Hope this helps.

Pete

[FDibbins]

so drop down box is in cell CD37 and its linked to CH21
however i need to be able to manually use CD37 but still retain the link to CH21

there is nothing magical about a drop down (Data Validation). It is exactly the same as if you had typed the entry in manually, the only differences being that a DD can save you some typing, help avoid typos and help restrict entry to only a specified "list". Other than that, there is basically no difference. You would refer to it in formulas etc the exact same way as if you were referencing a manually entered cell