linking seperate months in a book to keep a running total
Posted by Austin on July 18, 2001 1:25 PM
Hi Mr.Excel,
I am working a project that required me to link seperated months in a book to keep a running total.
Eg. I would creat a file that has the sales figures for 12 months(each book represents each month), then starting from Feb, I would creat a cell that allow me automatically adding the YTD sales figure from the previous months and so(the number from the book1 will add to book2, the number of the book2 will add to book3.. and so).
Can you please tell me how I can create such function?Any of your help is much appriciated.
Best Regards,
Austin
Posted by Cory on July 18, 2001 2:04 PM
This may be too easy, but...
Austin,
To link the cells from one workbook to another do this:
Say your monthly total is in cell A1 in each of the workbooks. You want the running total to show up in cell B2. Let's just do January and February to give you and idea...
Open both Jan and Feb books. In B2 of Feb type "=sum(A1" then click over to the Jan book and click on cell A1. Press enter.
Any help?
Cory
