A
AndreaV
I have a workbook that is comprised of daily bank deposits. Each worksheet
has a cell H3 that has the total money collected. I would like to create a
worksheet that will add the value in every H3 cell in the workbook. The
formula must capture all worksheets in the workbook as they are added. In
other words, I'd like a total of deposits for the year on an ongoing basis.
Can you also create a graph of the totals by month? The tab on each
worksheet reflects the date of the deposit (Mar 8 2010) or (Mar 5-6 2010).
has a cell H3 that has the total money collected. I would like to create a
worksheet that will add the value in every H3 cell in the workbook. The
formula must capture all worksheets in the workbook as they are added. In
other words, I'd like a total of deposits for the year on an ongoing basis.
Can you also create a graph of the totals by month? The tab on each
worksheet reflects the date of the deposit (Mar 8 2010) or (Mar 5-6 2010).