Calculation table - change 1 parameter and save data

Hi all!

I have a rather simple question but I have no idea how to cope with this!


Basically, I have a range from A14 to M31 with a lot of calculations. These calculations use a cell as reference (it's a merged cell A15->A31) which has a number in it that corresponds to a month number.

So right now my table calculates stuff for january (because that merged cell has a 1 in it). I would like to easily calculate stuff for each month and use some of the results in a chart.


One of my options is to copy/paste my table 11 times, change the 1 and put the other month numbers. That'll give me 12 tables from which I can select the individual cells I want to chart. That option seems quite heavy and unpractical even though it's the only one I'm capable of achieving.

I imagine there would be an easy way to have a macro or vba code or something else (I have never worked with that before) to
1. Calculate the table (which is done already since that's how it's laid down in my file)
2. Extract the result from some cells, put them in a summarized table
3. Change the month number
4. Calculate
5. Extract
6. etc...


What do you think would be the best way to do that? Copy/paste 12 times? or write some sort of magical thingy?
Again, I've never used VBA so even though what I want to do is very simple, I hope starting implementing code in a file is easy to do and to understand and that it still lets my file run smoothly.

Here's the file if it helps:

UNITES-wet-nut- new up.xlsx