Macro To Insert Remarks Based On Demand Value

[cathchin]

Hi All,

I need your expertise to set a macro to add remarks at Column AW with the criteria below:
1) if the demand will be consumed (whereby the value = 0/<0) on a particular month, it will state : example Sept'12
2) if by the end of the horizon the demand is able to consume = 0 @ Column AU, then remarks will be "Consumed"
3) If demand unable to consumed >0 @ Column AU, then remarks will be "not able to BurnDown thru whole horizon Demand"

Thank you so much...

[antoka05]

You could try with this code but I'm not sure that I've understood fine:

Please Login or Register  to view this content.

Regards,
Antonio

[cathchin]

Hi Antonio,

Thanks! You have understand this correctly! I've change the value to 16 for this line --> For c = 18 To 46 Step 2

However, I am a little confused with the macro below, though the value is correct. Can you please explain? Why I cannot use If .Cells(r, "at") = 0 instead?
Else
If .Cells(r, "at") > 0 Then
.Cells(r, "aw") = "Consumed"

Regards,
Catherine