From time to time I get asked about Numbers, how do you put the value from a cell in one
table into a cell in another table.
Now it's very simple once you know the trick but it's kind of too simple so sometimes it's
hard for people to see what the solution is.
You know you can do formulas where you say you add two cells together.
For instance I have two cells here with the values 3 and 6 in them.
In this cell I can start a formula here.
I'll do that with the equals key.
Then I can click here, hit plus and click there.
So B2 plus C2 and the result is 9.
But I could have done just one cell.
So I could do equals here and just click there, B2, and stop there.
Now what's there.
Well, it's just the value of this cell.
If I change this cell to something like 77 this other cell picks it right up.
It works the same whether it's in the same table or not.
So if I go in here and I hit equals, if I just click here to insert the value or the
reference for that cell which in this case will be table 1::B2 then I get the same thing.
If I change it here you can see it changes in both places.
Now it looks pretty complex to have this here but, you know, you can type that.
You can go Table 1.
It even gives you a little help there at the bottom.
Then you do two colons and then I would look and see this is B2 and I can type it.
But I don't have to.
I can just click.
So I can do equals click on that cell and it inserts it right away.
So let's look at a more practical example here.
For instance, here is a sheet that has two tables in it.
One table has Sales and it's got a total at the bottom.
I want to then put that here where then a commission can be calculated and the total
profit.
So I just want to carry this value over here.
So all I would do is click in there, hit equals, click there and you can see it inserts sales
colon colon and then C13 and there I go.
Whatever this value is it's going to be reflected here.
So if I change one of these numbers here you can see it updates the total which then updates
this cell as well.
I could have typed in this.
I could have typed in Sales and you can see it's even going to help me down here.
Then I could type in C13 and get the answer there.
So I can type it in or it's just much easier to click to grab it like that.
Now this works across tables in the same sheet but it also works across sheets in the same
way.
So here I've got the same thing.
I've put the results table here.
I could then reference this cell the same way.
I could go in here.
I'm going to hit equals.
Now I'm going to click here to switch sheets.
I'm still entering a formula here.
You can see I still have this floating formula I'm entering on the other sheet.
I'm can click there and then I hit Return and it's going to return me to where I started.
Where I was entering this formula in.
You can see it actually grabs the number from the other sheet.
It actually doesn't even need to include the sheet name in this because Sales is a unique
title.
If I was using no titles then it would need to have the sheet.
You can actually have better names than sheet 1 and sheet 2.
I can actually double click in here, I have to dismiss this, double click in here and
you can see I can name this Sheet One or something a little bit more descriptive here and then
I can use that in a formula as well.
So you don't have to leave these as sheet 1 and sheet 2.
But that's how you do it.
That's how you can have a value simply linked to another cell in another table or another
cell in a table in another sheet as well.