Private budget change start month with drop down box Excel 2007

[chrlau5]

I want to make my home budget a little smarter.
I want to add a function that makes it possible to change the start month in my budget sheet (Budget sheet with possibility to change start month) from a drop down box. When start month changed I want the starting month column cells to point at cells from the chosen starting month on another budget sheet (Main budget sheet) that holds the income and expenses.
I have seen this on my internetbank and I would like to be able to fast see how my budget looks when another starting month is chosen.
I also would like to choose the other 11 months from drop down boxes and get the data from the main budget corresponding to the month chosen. It would be smart if it could automatically select the correct months in the next 11 columns when starting month is chosen. I guess it could be som simple VB programming?

I appreciate all the help you can give me as this something I really would like to add.


Kind Regards Christian

[Keyur]

Hi Christain,

I have attached two files. both have same end result. see if the is what you are looking for.

BudgetHlookup.xls
I added validation list in cell B1 for selecting the starting month and then whole bunch of Hlookup formula in all the cells for data. Then added code in 'Sheet with changing month' that will autofill the months in the first row.

Please Login or Register  to view this content.

Budget-CopyPaste.xls
at first i wrote the code in this file that copied data from Sheet1 to Sheet2 based on the month, but then i realized that if you change data in the Main Budget sheet, it will not be updated on Sheet2 until you run the code again. So I thought it's better to have lookup formula, then the data in Sheet2 is always current. If you want you can still use this file by adding more event handlers. the code in the file is

Please Login or Register  to view this content.

Hope that helps.

[chrlau5]

Hey Keyur

Thanks a lot!!!! I will try it and then I get back to you. It is just great you took the time to help me to making a good budget sheet :-).

Kind Regards
Christian

[afernandes]

Hi Keiur,

I have exactly the same doubt as Christian. But I'm not able to open your files. Do you still have them? Your answer is dated from May 2009...

Many thanks,
Ana.

[afernandes]

Hi Keyur,

I have exactly the same doubt as Christian. But I'm not able to open your files. Do you still have them? Your answer is dated from May 2009...

Many thanks,
Ana.