• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating variation macro for excel


New Member
Hi everyone,

My name is Gautam. I have to create a macro which will capture the difference in value between the sum of 2 between 2 timeframe and provide a result that comments whether the particular value has increased or decreased

Example :- if the sum of red apples has increased by 5000 over the last month and the sum of green apples has fallen by 3000

Then macro should display final result " increase is due to red apples by 5000 and offset by decrease in green apples by 3000"

Can anyone help with the same