Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need formula for cumulative data-using prior worksheet (YTD)
I am looking for the function to use to be able to calculate data using the
prior worksheet, vs an absolute function using the same sheet. |
#2
|
|||
|
|||
Excel doesn't support relative sheet referencing; that is, you
can't write a formula like =PreviousSheet!A1 You'll either have to hard code the previous sheet's name, or use VBA to get the name of the previous sheet and incorporate that in to an INDIRECT function. E.g., Function PreviousSheet() As String PreviousSheet = Application.Caller.Parent.Previous.Next.Name End Function =INDIRECT(PreviousSheet & "!A1") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "travchev" wrote in message ... I am looking for the function to use to be able to calculate data using the prior worksheet, vs an absolute function using the same sheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS? | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
matching data formula? | Excel Worksheet Functions |