Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ML ML is offline
external usenet poster
 
Posts: 57
Default ROLLUP REPORT

Our boss wanted the report that shows the total for the last 12 months so
that each month when I add in a new month, it will drop the first month and
rerun the 12-month total with newly added month. For instance, in May, my
total runs from June 07 to May 08. Next month when I add June total in, I
want the 12-month total only run from July 07 to June 08, but I still want to
keep June 07 data in the table. I hope explained enough. Help!

Thanks,
ml
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting missing data from one report into another report... vlookupabyss Excel Discussion (Misc queries) 3 January 8th 08 03:26 PM
Automatic updating of a rollup worksheet when a new worksheet is a Marc A. Excel Worksheet Functions 1 August 7th 06 07:49 PM
Automate Excel report to place certain data into existing report? Craig Harrison Excel Worksheet Functions 3 July 25th 06 01:54 PM
Header in Report Manager Report Steve K Excel Discussion (Misc queries) 0 March 7th 06 07:32 PM
Rollup worksheets into a master worksheet - automatically? Annabelle Excel Discussion (Misc queries) 0 October 18th 05 07:54 PM


All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"