PLEASE HELP ME!!!

[AndreasLim92]

I want to check Type and Size Material and Part before start to cutting off.
I try to solve it but i don't know how to solve it.
Please someone help me.

[paulked]

Yes, well, hmm...

That's a lot of code with comments unreadable, but I doubt it would help me at all if I could read them! :hide:

[SamT]

Dim input_z_row As Integer: input_z_row = Range("D5").Row Wont work
All the
input_z_row = Range("D5").Row Parts of your declarations must be in the code after the
Sheets(1).Activate and the Range assignments must be preceded by a dot... ".Range(etc...)"


Or, you can use
Dim input_z_row As Integer: input_z_row = Sheets(1).Range("D5").Row


I didn't go any further in your code.

[AndreasLim92]

Please Help me.
I am trying to Compare Material of Size and Part with Part of Type of Size.
I have done with Cutting Plan from Part of Length with Material Length.
But all of Parts get cutting off all Material without check the type and size.

I want to cut but with the same type and size.
Please help me to solve this function.



Yes, well, hmm...

That's a lot of code with comments unreadable, but I doubt it would help me at all if I could read them! :hide:

[p45cal]

SamT, lines like:
Dim input_z_row As Integer: input_z_row = Range("D5").Row '//Materials Data Input
Dim input_z_column As Integer: input_z_column = Range("D5").Column '//Materials Data Input
Dim input_r_row As Integer: input_r_row = Range("I5").Row '//Parts Data Input
Dim input_r_column As Integer: input_r_column = Range("I5").Column '//Parts Data Input
are just silly. It may as well be:
Dim input_z_row As Integer: input_z_row = 5 '//Materials Data Input
Dim input_z_column As Integer: input_z_column = 4 '//Materials Data Input
Dim input_r_row As Integer: input_r_row = 5 '//Parts Data Input
Dim input_r_column As Integer: input_r_column = 9 '//Parts Data Input
Range("D5").row is 5 on any sheet, anywhere.

[AndreasLim92]

Thank you very much. The coding is more simple.

[paulked]

I'm wading through it, but before I go any further it strikes me there is not enough 200x200x8x12 girders to meet the demand. You have 95,110mm in Material and need 129,160mm?

[AndreasLim92]

Before I do cutting plan, first all check the Length of parts for the cutting in Material stocks. parts of length compared with Material of Length. if there is no one can be cut then cutting plan will not going but if there is one can be cutting = [Material Length - Parts Length] and the remain will check again with other parts length can be cut again or not. Until here, I solved it but for the [Type] and [Size] I don't how to compared it, before do cutting plan.

[paulked]

So it works ok if you only have the one type and size in "B" & "C" that matches type & size in "G" & "H"?

[AndreasLim92]

Yeah. That exactly what I cannot solving now.

[paulked]

Ok, 1st step is change the type to SM490A in column "G" :whistle:

I'm finding my way slowly, please be patient :thumb

If anyone else wants to step in, please feel free... I've got work to do this week :wink: