Macro for repeat with if statement

**Jabj** · 10-19-2012, 04:39 AM

Hi all,

My problem is that I'll like to have a macro which can take one number which are given by a specific country, month and year and then divide that number with another number for the same country, month and year (the denominator are suppose to by divided further by 12 only due to a yearly frequency). Then the macro should continue until there isn't any conutry left.

I've attach the example in order to try to simplify what I'm after... In sheet 3 the formula and outlook are given as I would like to have the macro to do.

Thanks in advance

**Jabj** · 10-19-2012, 05:33 AM

I appreciate if anyone have a suggestion

**Jabj** · 10-20-2012, 08:19 AM

Anyone who are able to help?

**6StringJazzer** · 10-20-2012, 12:59 PM

Your example already sets this up to use formulas. Why do you need to use macros?

**Jabj** · 10-21-2012, 04:10 AM

I know but let's say I got 15 different countries then it would be pleasant to have a macro which took into account the number of countries... If you follow ?