View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
ng66 ng66 is offline
external usenet poster
 
Posts: 11
Default PULLING A VALUE FROM A CELL ON ANOTHER PAGE/WORKSHEET

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?