Right click sheet tabview codeinsert thisSAVE workbook
Private Sub Worksheet_Change(ByVal Target As Range)
Set myrng = Range("e2:e15")
Application.EnableEvents = False
If Not Intersect(Target, myrng) Is Nothing Then
x = 100 - Target
For Each c In myrng
If c.Address < Target.Address Then c.Value = x / 13
Next
End If
Application.EnableEvents = True
End Sub
--
Don Guillett
SalesAid Software
"Jeff" wrote in message
oups.com...
I have range of cells that are the same right now, and they add up to
100:
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
7.142857
100
I would like to be able to change on of those values, and the others
adjust to still add up to 100. Any ideas?