ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   2007 and running balance across worksheets (https://www.excelbanter.com/excel-worksheet-functions/156858-2007-running-balance-across-worksheets.html)

Kdahlin

2007 and running balance across worksheets
 
I want a running balance or account that spans accross successive worksheets.
One worksheet per day. So, that at the end of all the worksheets I have a
total of all the values.

(Think how your multipage phone bill tallies the total for each page at the
bottom of each page. Then on the last page it tells you the overall
cumulative total. )

To make things more interesting...The cell that carries the page balance may
not always be in the same cell. Say F29

Does Excel 2007 bring relief to this issue? I've been using 2003 version.


All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com