marco cannot execute step by step.

Dear Expert,

i have created a macro including a lot of steps.

in my sceranio, i have created a macro like this:

step 1:

Row 1 = row 2 + row 3

Step 2:

row4 = row 1.

Step 3:

IF

row4 > row5

write an alert.

When i run this macro, it can only execute step 3. i don't know why?

please explain for me and correct it.

And tell me how can i execute marco at aggregated level and location level or product level.

thanks so much.