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