Hello,

I need some help.

I am using a data validation list to help people populate the
destination cell with the required value.
The data validaton list is populated using a formula that references
to a table on another sheet.
Users are expected to change the values on this table to their
suitable name.

For example:

Sheet
1: Sheet 2:

A
D
Table
Validation list
1 <Account 1>
='Sheet 1!'A1
2 <Account 2>
='Sheet 1!'A2
3 <Account 3>
='Sheet 1!'A3

For example if the user chances the name '<Account 1>' to 'Chemist'
then the data validation list auotmatically updates. This will alos
update the drop down list in the destination cell that has the data
validation applied. However, is there away of also updating the cells
that have already had the orginal value selected, i.e. '<Account>' to
'Chemist' as users can change the name of the values at any point in
time.

I have tried to use =IF(D1="<Account 1>",'Sheet 1!'A1,D1).
However, once I select another value from the drop down list it
overwrites the formula entered in the cell.

Does anyone know a good solution to this problem or a good work
around.

Thanks for your help!

All you need to know about data validation is here:
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal08.html



--
RyGuy


"(E-Mail Removed)" wrote:

> Hello,
>
> I need some help.
>
> I am using a data validation list to help people populate the
> destination cell with the required value.
> The data validaton list is populated using a formula that references
> to a table on another sheet.
> Users are expected to change the values on this table to their
> suitable name.
>
> For example:
>
> Sheet
> 1: Sheet 2:
>
> A
> D
> Table
> Validation list
> 1 <Account 1>
> ='Sheet 1!'A1
> 2 <Account 2>
> ='Sheet 1!'A2
> 3 <Account 3>
> ='Sheet 1!'A3
>
> For example if the user chances the name '<Account 1>' to 'Chemist'
> then the data validation list auotmatically updates. This will alos
> update the drop down list in the destination cell that has the data
> validation applied. However, is there away of also updating the cells
> that have already had the orginal value selected, i.e. '<Account>' to
> 'Chemist' as users can change the name of the values at any point in
> time.
>
> I have tried to use =IF(D1="<Account 1>",'Sheet 1!'A1,D1).
> However, once I select another value from the drop down list it
> overwrites the formula entered in the cell.
>
> Does anyone know a good solution to this problem or a good work
> around.
>
> Thanks for your help!
>

There's a sample file here that updates previous selections:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0022 - Update Validation Selections'

(E-Mail Removed) wrote:
> Hello,
>
> I need some help.
>
> I am using a data validation list to help people populate the
> destination cell with the required value.
> The data validaton list is populated using a formula that references
> to a table on another sheet.
> Users are expected to change the values on this table to their
> suitable name.
>
> For example:
>
> Sheet
> 1: Sheet 2:
>
> A
> D
> Table
> Validation list
> 1 <Account 1>
> ='Sheet 1!'A1
> 2 <Account 2>
> ='Sheet 1!'A2
> 3 <Account 3>
> ='Sheet 1!'A3
>
> For example if the user chances the name '<Account 1>' to 'Chemist'
> then the data validation list auotmatically updates. This will alos
> update the drop down list in the destination cell that has the data
> validation applied. However, is there away of also updating the cells
> that have already had the orginal value selected, i.e. '<Account>' to
> 'Chemist' as users can change the name of the values at any point in
> time.
>
> I have tried to use =IF(D1="<Account 1>",'Sheet 1!'A1,D1).
> However, once I select another value from the drop down list it
> overwrites the formula entered in the cell.
>
> Does anyone know a good solution to this problem or a good work
> around.
>
> Thanks for your help!


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

On Jul 4, 11:09*pm, Debra Dalgleish <d...@contexturesXSPAM.com> wrote:
> There's a sample file here that updates previous selections:
>
> * *http://www.contextures.com/excelfiles.html
>
> Under Data Validation, look for 'DV0022 - Update Validation Selections'
>
>
>
>
>
> ronia...@hotmail.com wrote:
> > Hello,
>
> > I need some help.
>
> > I am using a data validation list to help people populate the
> > destination cell with the required value.
> > The data validaton list is populated using a formula that references
> > to a table on another sheet.
> > Users are expected to change the values on this table to their
> > suitable name.
>
> > For example:
>
> > * * * *Sheet
> > 1: * * * * * * * * * * * * * * * * * * * * * * * * * * * * Sheet 2:
>
> > A
> > D
> > * * * * *Table
> > Validation list
> > 1 * <Account 1>
> > ='Sheet 1!'A1
> > 2 * <Account 2>
> > ='Sheet 1!'A2
> > 3 * <Account 3>
> > ='Sheet 1!'A3
>
> > For example if the user chances the name '<Account 1>' to 'Chemist'
> > then the data validation list auotmatically updates. This will alos
> > update the drop down list in the destination cell that has the data
> > validation applied. However, is there away of also updating the cells
> > that have already had the orginal value selected, i.e. '<Account>' to
> > 'Chemist' as users can change the name of the values at any point in
> > time.
>
> > I have tried to use =IF(D1="<Account 1>",'Sheet 1!'A1,D1).
> > However, once I select another value from the drop down list it
> > overwrites the formula entered in the cell.
>
> > Does anyone know a good solution to this problem or a good work
> > around.
>
> > Thanks for your help!
>
> --
> Debra Dalgleish
> Contextureswww.contextures.com/tiptech.html
> Blog:http://blog.contextures.com- Hide quoted text -
>
> - Show quoted text -

Thanks Debra, that worked!!!