Forum Discussion
Displaying a cell in another sheet
I have a formula, which is a total, to appear in a cell in another sheet of the same file.
Is that a question? There are a number of ways to accomplish it. The easiest is simply to be in the target cell, enter an equals sign, and then navigate to the cell containing the total and hit "Enter"
A smarter way is to "name" the cell containing the total. Have your cursor on the cell that now contains the total, then, under the "Insert" menu, go to Name, Define -- and give that cell a name "DesiredTotal" or something else more representative. Then in the target cell you can just enter =DesiredTotal