I did a re-evaluation of this question.
It appears that you have a 4000 length from which you need the requested
cuts.
If so, put your list of requested cuts in range g5:g9 and run this.
Then run again for the second series of cuts
Sub getcuts()
ml = 4000
cuts = 0
For Each c In Range("g5:g9")
If c 0 And c < (ml - cuts) Then
cuts = cuts + c
ms = ms & "+" & c
c.ClearContents
End If
Next c
MsgBox ms
MsgBox cuts
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"davers" wrote in message
...
I dont know if this is the right place to ask this question but i am
looking
for a simple excel formula to create a cutting list.
ie
1200
1400
1800
2000
600
The above lengths needs to be cut from 4000
so 1200 + 1800 = 4000 and 1200+2000+600 =3200
so i require 2 lengths at 4000, surely its a simple excel formula, any
help
would be much appreciated.