VBA Help

[wildest_jjk]

Hi guys,

I'm trying to write my first VBA script as failing miserably. Essentially I am trying to put a sheet of data in various groups depending on some values in the cells.

I guess the first question would be is there an easier way of doing this?

If not then what is the easiest way to find the last row on the sheet? I see a lot of suggestions using End(xlUp) or something like that but I cannot seem to get this to work!

Thanks

 

[wildest_jjk]

Thanks for that.

Does anyone know if there is a simpler way of grouping large data based on some criteria?

I'm really struggling with the VBA...

 

[wildest_jjk]

Ok I'm making progress

Could someone tell me if this is syntactically correct please?

If Cells(5, k).Value = "" Or Cells(5, k).Value + total < 75 Then

 

[wildest_jjk]

k = integer variable
total = integer variable