Hello
Im own a small scale industry where I manufacture aluminium windows. My aluminium raw material arrives with each piece being 3660 millimetres.
In these I will cut them to the sizes for the windows I require, which varies very randomly from 200 mm to 2400 mm. But the problem is if we do not optimize it properly, we will me wasting a lot of aluminium which will prove very costly.
So I need a calculation system where if I just enter the sizes I require in a list like this,

660
520
482
1220
548
and so on....

It should automatically arrange it in such an order so that if I cut in that order I will be wasting very less material.

I am well versed with excel and VBA, but I am not able to figure out how to go ahead to create this macro.. Any help will be greatly appreciated :D
Thank You