Displaying a cell in another sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2084543%22%20slang%3D%22en-US%22%3EDisplaying%20a%20cell%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084543%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20formula%2C%20which%20is%20a%20total%2C%20to%20appear%20in%20a%20cell%20in%20another%20sheet%20of%20the%20same%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2084543%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2084993%22%20slang%3D%22en-US%22%3ERe%3A%20Displaying%20a%20cell%20in%20another%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2084993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F938225%22%20target%3D%22_blank%22%3E%40Night_Rider82%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20a%20question%3F%20There%20are%20a%20number%20of%20ways%20to%20accomplish%20it.%20The%20easiest%20is%20simply%20to%20be%20in%20the%20target%26nbsp%3B%20cell%2C%20enter%20an%20equals%20sign%2C%20and%20then%20navigate%20to%20the%20cell%20containing%20the%20total%20and%20hit%20%22Enter%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20smarter%20way%20is%20to%20%22name%22%20the%20cell%20containing%20the%20total.%20Have%20your%20cursor%20on%20the%20cell%20that%20now%20contains%20the%20total%2C%20then%2C%20under%26nbsp%3B%20the%20%22Insert%22%20menu%2C%20go%20to%20Name%2C%20Define%20--%20and%20give%20that%20cell%20a%20name%20%22DesiredTotal%22%20or%20something%20else%20more%20representative.%20Then%20in%20the%20target%20cell%20you%20can%20just%20enter%20%3DDesiredTotal%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a formula, which is a total, to appear in a cell in another sheet of the same file.

1 Reply

@Night_Rider82 

 

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