i have 2 worksheets - called GL 8001 and GL 8003. These 2 worksheets use the same logic, just different filter and parameter values. Now, the result from GL 8001 is stored in a Calculated field called NewItemValue8001. Similarly, the result from GL 8003 is stored in a Calculated field called NewItemValue8003.
I want to have a Grandtotal Worksheet that adds NewItemValue8001 and NewItemValue8003 (and more worksheets if there are any).
Is this possible? Ideally, i would want the Grand Total to reflect any changes that are made to the 'constituent worksheets'
You cannot refer to the cell elements from one worksheet to another as the worksheets are view and nor like Excel. If you want to add data across multiple tables, you can blend the data. Could you please share the workbook so someone can help you?