refresh validation list

  • Thread starter Thread starter robert
  • Start date Start date
R

robert

Hi,

I have CELLS that get their value from a validation list which gets its
values from a master list.
When I change the master list the validation list updates but not the values
i chose in the individual CELLS.

Does anyone know of anyway of updating this cells.
When I hit the drop down the corrected values are there and I can do it that
way but
it means I have to refresh everything by picking and one at a time

thanks
robert
 
Hi
don't think this can be done. How should Excel know what the new value
should be
 
Robert
What is in the CELLS? Is it formulas that relate back to the validation
cell. If not, then how do the CELLS get their values? HTH Otto
 
Back
Top