Drop down boxes

T

themase

Hello

i have a column of 'names' which i have used a dropdown list to produce i.e.

date name(drop downlist)
01/01/2009 john

i.e john dave etc in the list is there a way that if a change john to Jsmith
that this will update all the rows that 'john' was chosen for!
 
S

sidm via OfficeKB.com

themase said:
Hello

i have a column of 'names' which i have used a dropdown list to produce i.e.

date name(drop downlist)
01/01/2009 john

i.e john dave etc in the list is there a way that if a change john to Jsmith
that this will update all the rows that 'john' was chosen for!

Edit>Replace ( Replace john to Jsmith )
 
Top