Calculation table - change 1 parameter and save data

[dourpil]

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

[Fotis1991]

Unfortunately you have to change your title according the forum rules.

[dourpil]

Unfortunately you have to change your title according the forum rules.

Not an easy thing to do when I can't define what I want. I tried though but I feel the new title is even less accurate xD

[Fotis1991]

It is much better now!

Thank you.

[dourpil]

Much better indeed, I think I got much more help with a clearer title!


.. xD

[Fotis1991]

Your ironic tone... will not help to find the solution to your problem.

[dourpil]

Oh please don't take my remark too seriously. Yes I was being ironic, but it was just a fun way of 'upping' the thread. I'm not mad at all and I know a lot of threads just fall unanswered for various reasons. I thought this was funny