I require a VBA function created that will calculate the amount of stardard size sheets required to cut a number of smaller sheets from.
Example: Public Function GetSheetsRequired(iSheetHeight as Int, iSheetWidth as Int, iSheetCutHeight as int, iSheetCutWidth as int, iQuantity as int).
Call Example: GetSheetsRequired(1200, 2400, 600, 400, 20) should return 2, as it will require 2 1200 x 2400 sheets to cut 20 600 x 400 sheets.
Be aware that the cut required may be 4000 x 600, in this case only 1 sheet is required, as it is not possible to have one single piece of this size cut from a sheet that is only 1200 x 2400.
Where possible the cut sheet should be in one piece except in cases like the one above.
This will be a very simple function that will output the number of pieces required and will take care of the exceptional cases also. Pls. award the project and get the delivery on the same day. Thanks, ssTechnosoft.