LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Having a formula provide a running total from multiple worksheets

Currently, I have a workbook with multiple worksheets. I am trying to
provide a return of the prior 3 months. Each month, when I add the next
month data, I have to update these formulas to refer to the data in the prior
two months worksheets i.e. this month I had to update last months formula
from pulling data from the Mar, Apr, & May worksheet to the Apr, May, and Jun
worksheets. How can I get a formula to automatically update and pull the
prior two months data to complete the return?
 
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
Running total formula DBane Excel Worksheet Functions 0 June 2nd 06 07:38 PM
Total or Count based on multiple conditions CC Excel Discussion (Misc queries) 4 May 17th 06 10:50 PM
Formula for running total santaviga Excel Worksheet Functions 0 April 27th 06 10:46 PM
running total from the same field on multiple sheets as i add she obviscator Excel Worksheet Functions 2 April 15th 06 06:34 PM
Help with LARGE formula with multiple worksheets Aleisha Mollen Excel Worksheet Functions 1 September 18th 05 10:45 PM


All times are GMT +1. The time now is 08:00 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"