Prev: where can i find credit notes
Next: Div 0 help
From: themase on 17 May 2010 04:45
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!
From: Roger Govier on 17 May 2010 05:15
Hi

That won't happen by editing the name if the validation list.
There is no connection between the cell containing the value, and the
original source.

After editing your dropdown list, then use Control+H (Find and Replace)
Find John Smith
Replace London Clinic
Replace All

--
Regards
Roger Govier

themase wrote:
> 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!
 | 
Pages: 1
Prev: where can i find credit notes
Next: Div 0 help