Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running total formula | Excel Worksheet Functions | |||
Total or Count based on multiple conditions | Excel Discussion (Misc queries) | |||
Formula for running total | Excel Worksheet Functions | |||
running total from the same field on multiple sheets as i add she | Excel Worksheet Functions | |||
Help with LARGE formula with multiple worksheets | Excel Worksheet Functions |