Data Validation lists update orginal cell with list update

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 he
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal08.html



--
RyGuy


" 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'

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 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'





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