Prev: Ribbon
Next: Three Variable Correlation
From: themase on 17 May 2010 07:34
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!
From: sidm via OfficeKB.com on 17 May 2010 08:05
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!

Edit>Replace ( Replace john to Jsmith )

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

 | 
Pages: 1
Prev: Ribbon
Next: Three Variable Correlation