Hello

i have a drop down box which contains names of workers this has been used to
populate who works where in a spread sheet! what i need to do is edit the
values in the list (which i can do) but i need the data to be updated in the
spread sheet example

if the value is 'john smith' in the spread sheet from a drop down i want to
change this to 'london clinic' and this in turn updates the value in the
field!