How to update edited values in validation list?

[royend]

Hi,
I am having problems with my validation list when I have updated the
source data for my validation list.

Example:
In [A4, A8] I have a list of 5 book-titles (e.g. A4 = "TrueStory").
In [G4, ...] I have a dropdown list which uses the data in [A4, A8] to
select from.
I then choose "TrueStory" in G4, before I later alter A4 to
"SadStory". However, the edit in A4 does not have any effect on G4.
Why? And is it possible to make G4 automatically changed according to
A4?

The list is updated, which actually means that "TrueStory" now is not
allowed according to the validation list...

This is the example I followed to create my list:
http://cyberskillsguide.com/11/setting-up-data-validation-in-excel-2007/

Hope you know how to fix this.
Thanks in advance...

 

[Debra Dalgleish]

The dropdown list is connected to the source list, but the cell contents
are not. There's a sample workbook here that uses programming to update
the previous selections, if the list is changed:

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

Under Data Validation, look for 'DV0022 - Update Validation Selections'
(not tested in Excel 2007)

Hi,
I am having problems with my validation list when I have updated the
source data for my validation list.

Example:
In [A4, A8] I have a list of 5 book-titles (e.g. A4 = "TrueStory").
In [G4, ...] I have a dropdown list which uses the data in [A4, A8] to
select from.
I then choose "TrueStory" in G4, before I later alter A4 to
"SadStory". However, the edit in A4 does not have any effect on G4.
Why? And is it possible to make G4 automatically changed according to
A4?

The list is updated, which actually means that "TrueStory" now is not
allowed according to the validation list...

This is the example I followed to create my list:
http://cyberskillsguide.com/11/setting-up-data-validation-in-excel-2007/

Hope you know how to fix this.
Thanks in advance...