View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sisko101 sisko101 is offline
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?