Prev: Change listbox text size in Excel 2007
Next: Excel - Ignoring the contents of cells when there are letters in the cell
From: Karen on 20 Jan 2010 09:13 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 20 Jan 2010 12:29
Excel 2007 PivotTable Running totals for last 3 months. With macro. http://c0444202.cdn.cloudfiles.rackspacecloud.com/01_20_10.xlsm |