themase wrote:
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!

EditReplace ( Replace john to Jsmith )

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1