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
Bookmarks