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!