Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update edited values in validation list?
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/setti...in-excel-2007/ Hope you know how to fix this. Thanks in advance... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to update edited values in validation list?
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) royend wrote: 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/setti...in-excel-2007/ Hope you know how to fix this. Thanks in advance... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Update validation list? | Excel Worksheet Functions | |||
Update Validation List | Excel Discussion (Misc queries) | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
update a date cell only when worksheet is edited | Excel Discussion (Misc queries) | |||
Auto Update A Validation List | Excel Worksheet Functions |