Hi everyone,
I am trying to complete the following as a VBA loop for a production plan: The values in column A need to be summed for every occurrence of 40 in column B. The result is going to appear in column C as the total of all values until the next occurrence of 40. For example 2 + 12+ 4 = 18 appears in cell C1, and 8+15 = 23 appears in cell C4. It looks simple but somehow my approaches do not work.
I am trying to complete the following as a VBA loop for a production plan: The values in column A need to be summed for every occurrence of 40 in column B. The result is going to appear in column C as the total of all values until the next occurrence of 40. For example 2 + 12+ 4 = 18 appears in cell C1, and 8+15 = 23 appears in cell C4. It looks simple but somehow my approaches do not work.