Forum Discussion
Linking a calculation in one worksheet to another
As a comment, it's necessary to type such formula. Start typing = into the cell, after that click on L3 in sheet March, Enter.
However, much more reliable will be to use formulas to return data into the summary sheet. Initial variant could be
with that to keep exactly the same Expense list for each month. You may add only actual expenses in the month, order is also not important. Formula is
=IFNA(INDEX(March!$L:$L,MATCH($B3,March!$B:$B,0)),"")That could be other improvements, but at least this one.
I found the answer: I need to use a formula of " =[name of worksheet]![cell reference]
So to get the result I want, in cell H3 in the "annual" workbook, i inserted the formula "=March!L3 "
L3 is the cell with the calculation, and if ever change the numbers in the march workbook, the calculation in L3 changes, and the number in H3 in the "annual" workbook updates as well.
Thanks for your time Nikolino!
As a comment, it's necessary to type such formula. Start typing = into the cell, after that click on L3 in sheet March, Enter.
However, much more reliable will be to use formulas to return data into the summary sheet. Initial variant could be
with that to keep exactly the same Expense list for each month. You may add only actual expenses in the month, order is also not important. Formula is
=IFNA(INDEX(March!$L:$L,MATCH($B3,March!$B:$B,0)),"")That could be other improvements, but at least this one.
- Thanks Sergei!
Montreal_Mike , you are welcome