Data\Validation

[marc747]

I have a cell in excel that has a Validation list, and the list is a
sum of other cells so the values change based on what is entered in
other cells. my question is, is it possible to have the cell update by
itself.
Example I have completed entering data in the cells and then I go and
select an option from the validation list then I go back and change
some data that I entered originally, at this point is it possible that
the validation option that I had selected can be updated automatically
instead of me going back and selecting it again.
Thanks.

 

[Debra Dalgleish]

You may be able to update the selections with programming. There's a
sample file here:

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

Under Data Validation, look for 'DV0022 - Update Validation Selections'

 

[marc747]

Thanks, I checked and tried very good, except one thing the validation
list gets the data from a source that it has SUM formulas so when I
tried it did not work, any ideas what I can do to make it work.
Basically I have 3 cells (M1:M3) this cells have formulas and I have
one cell that is the validation list to select one option. thanks