Excel formula in Numbers

[stressymum]

I am a newly converted Mac user and have some entrenched Excel habits, and try as I might, I couldn't locate this Excel formula in Numbers.

In Excel, I use "=C55 (or cell reference)" to copy that particular value from one worksheet to another. I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.

If anyone could help with this, I would most appreciate it. Thank you.

 

[mysterytramp]

That's how it SHOULD work in Numbers, too. Could just be there's a subtle change in gestures. At any rate, you can refer to cells within tables:

=C55

Within sheets:

=Table 1 :: C55

Within environments:

=Sheet 1 :: Table 1 :: C55

When they work, the reference is "bubbled" in a pastel color.

Quick Numbers plug -- not sure Excel does this, and it's pretty cool -- Let's say you have a table with columns 2008, 2009 and 2010; and rows Sales and Total.

You can refer to them:

=Total 2010

or even

=2010 Total

No extra naming needed.

mt

 

[flat five]

I do this by clicking on the cell where I want the value to be copied to, type = and then switch to the other worksheet and click on the cell I want to copy. And voila, I am now back onto my 1st worksheet with the value showing. I do this because the value I want to copy to this cell changes regularly.

right, that's exactly how numbers works also..
what is happening to you when you try it?