From: Karen on
I have a workbook set-up that contains two worksheets. One work sheet has the
current date and totals for individual inventory. The second worksheet has
the individual months with that months inventory. How do I set a formula in
the first sheet that will calculate the running total for the last 90 days
and automatically generate new totals when the date is changed on workeet 1?
From: Herbert Seidenberg on
Excel 2007 PivotTable
Running totals for last 3 months.
With macro.
http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_20_10.xlsm