If you add 5 to one of them, subtract 5 from one of the others...
Maybe you were looking for something a bit more complicated though.

Tim



"Laurie" wrote in message
...
I am trying to create a macro/function that will allow me to change a
percentage in a row, adjust the remaining percentages to still keep my
total
100%. I am lost and need help.

Thanks!