[Solved] Calculating across different sheets

[ghia589]

Thanks to all that helped my old memory. Great service as always.

Want to write formula as follows:

I have 2 sheets called apple and baker. As an example, I want cell b14 on the sheet called baker to automatically show what is typed into cell a12 on page apple. I use to know how to do this, but old age is setting in.

What would be the formula typed into cell b14 on baker?

Many thanks, Tom

[robleyd]

Assuming both sheets are in the same file:

Code: Select all

=apple.A12

Or you can do the process of typing = into B14 on baker and then click on the target cell in apple.

[ghia589]

Thanks David. I actually have 114 sheets in the same file, and your suggestion worked fine for two sheets labeled T and S. I decided to try a longer sheet name and typed:

=Twelve Days of Christmas.A12 and got Err509

I assume I need to do something different if a sheet has multiple words in its title????

[MrProgrammer]

=Twelve Days of Christmas.A12 and got Err509
I assume I need to do something different if a sheet has multiple words in its title????

Or you can do the process of typing = into B14 on baker and then click on the target cell in apple.

Learn to let Calc help you construct the formula. Type an equal sign in the cell where you want the formula. Click sheet tab Twelve Days of Christmas. Click cell A12. Click the sheet tab which contains the formula (the one where you typed the equal sign). Press Enter to complete the formula. Look at that cell to see the correct syntax.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[RusselB]

MrProgrammer's recommendation is your best bet, as the simple solution, namely to tell you that you need quotation marks around the sheet name when it contains multiple space separated words, does come with some exceptions that are dependent on the actual characters in the sheet name,
The recommendation will, not only show you the correct syntax for that situation, but will also allow you to learn/recall a skill.

Edited for clarification

[Zizi64]

you need quotation marks around the sheet name when it contains multiple words,

...or you can use "_" sign instead of the space " " character for the sheet names:
Twelve Days of Christmas -> Twelve_Days_of_Christmas
In this case not needed to use the quotation marks in the formula.