Pulling weekly budget data into monthly budget

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

Mark,
If every sheet has the same layout (i.e. cell C14 is the same on every sheet) then on your summary sheet enter =sum(January:December!C14). This will sum cells C14 on all the sheets in your workbook that are between sheet January and sheet December.
Hope this helps and hope you have a speedy recovery. GMc

when I do this it asks for the address of each file I want to pull c14 from, and I then have to do this for every cell I want the formula in i.e. for c15, c16, c17 etc :-( I wonder if I can do this quicker using some kind of VBA or some other smarter less manual way.

Thanks guys

Are all your worksheets in the same workbook?