Hi there!

Sure this won't be too hard for most of you out there...

I am sitting at home after my surgery and have a bit of extra time to sort out my personal finances! At the moment I have a yearly budget (for 2008), monthly budgets and weekly budgets, all with the same columns and rows. When I originally linked these all up to each other, I did it manually. For example in my monthly budget for 'food shopping' on row 4 I used the basic formula to add the corresponding weekly budgets up with the formula: =(hyperlink to week1, row 4) + (hyperlink to week 2, row 4) etc. As you can imagine doing repeating this formula every time is very tmie consuming.

I have heard about using VBA but I have never used it before. Can someone help me to link my budgets up with VBA or some other smart way of doing it!



Thanks in advance

Mark