Drop down boxes

[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!

 

[sidm via OfficeKB.com]

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 )