hi,

if i have 12 in cell a1 and 24 in cell f1 i want to be able to delete or adjust value in cells b1, c1, d1, e1.

example a1 = 12 b1 = 2, c1 = 4, d1= 7, e1= 11.
i want to delete the values in b1,c1, and adjust d1 to 1 and then adjust f1 to 12 which equale a1.

this can happen in 200 cells
is there a macro that can do this

thank steve