I hoping to find a way to change the values in 3 cells in one operation.
I was hoping Scenarios might be the answer but I cannot find a way to make that work.
Perhaps multiple operations would do it.
The problem should be a simple one to solve but I am stuck with manually changing the 3 cells at the moment. The three values to change are in C52, C53 and C54 to reduce or increase values in the three cells at a single operation.
Thanks for the suggestion.
I don’t think I would ever have hit on a form control as a possible resolution.
Just need to tweak the increments and the upper and lower limits.
Chris
You could also edit the cell with the base value directly, possibly with a validation rule. The slider is just a gimmick.