Another way.

Select the "sending" cell
edit|copy
Go to the "receiving" cell
edit|paste special|click paste Link.

But often times, you'll want to modify that formula.

='Sheet 99'!a1
will return a 0 if that cell is empty.

You could use:
=if('Sheet 99'!a1="","",'Sheet 99'!a1)

If it's empty, return something that looks blank. Else return the value.

ng66 wrote:

When it was just me, I couldn't figure out how to enter that I wanted the
value from the first sheet, so I gave up and decided to ask the experts.

For some strange reason John's answer seemed hard because I got used to
having to enter a formula (yeah, I don't know what I've been smoking
either!), so I tried what Allan suggested, but typing in "=sheet1!s261"
didn't work. I got one of those ###whatever errors. So I looked at John's
again with an un-formulaic maind, and thought, okay, c'mon, it couldn't be
that simple, but, guess what?!! It was!! And it worked perfectly... (o:

Thanks to everyone who answered all my newbie questions. I've been meaning
to learn this program for quite a while, and now that I kinda understand how
it thinks and what it wants from me, I think I may use it more... (o:

"SteveW" wrote:

John and Alan's answers work
What did you try ?

Steve
On Fri, 26 Jan 2007 00:56:01 -0000, ng66
wrote:

Can you do it?


--

Dave Peterson