Data\Validation

  • Thread starter Thread starter marc747
  • Start date Start date
M

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.
 
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
 
Back
Top