I have formula-driven values in named lists I am using with Data
Validation, Excel 2003. My problem: The original selected response in the
DV-assigned cell stays the same, but its formula-driven value is no longer
correct after formulas in other cells/lists create a change in the values in
my original DV list. Because the originally-selected value in the dropdown
is also generating values elsewhere, this is causing huge problems in my
program. I have hundreds of choices, and they all depend on each other. Is
there any way I can make the DV originally-selected result update
automatically to its new value (i.e. to the recalculated value in the list)
without clicking on the cell containing the dropdown and re-selecting its
equivalent new value?
If there's code for this, please explain as clearly as possible -- I'm
just a babe in that particular woods. Thanks! Brenda