Hello,

I need some help with building a macro in Excel.

I have two sheets, one with last-year data income (Sheet1), and another one with todays accounting summmary for a month(sheet2).

In sheet 1, there is two columns (B14:B33) and (G14-G33) that contains the last year monthly income.As you might understand, these cells have to change from month to month. This is what I want the macro to do.


Sheet1 has these numbers in the same correct order from B3 to B22 and B27:B46. This is, althoug, just for the first month in the year. I have also made a drop down list containing all the 12 months. This cell is "U1"


What I want to happen is following:

If I choose "January" in cell "U1", I want B3:B22 from Sheet1 to be inserted in B14:B33 in Sheet2.
At the same time i want B27:B46 in Sheet1 to be inserted into G14-G33 in Sheet2

If I Choose "February" in cell "U1", I want C3:C22 from Sheet1 to be inserted in B14:B33 in Sheet2.
At the same time i want C27:C46 in Sheet1 to be inserted into G14-G33 in Sheet2

If I Choose "March" in cell "U1", I want D3:D22 from Sheet1 to be inserted in B14:B33 in Sheet2.
At the same time i want D27:D46 in Sheet1 to be inserted into G14-G33 in Sheet2

and so on for all the 12 months.


How can I do this?

with best regards

Stian