If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Drop down box!
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! |
#2
|
|||
|
|||
Drop down box!
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! |
Thread Tools | |
Display Modes | |
|
|