I need current value of one worksheet into another cell?

[Ryan]

I am trying to put the value of one worksheet into another cell in another
worksheet.

[Paul B]

Ryan, will something like this work? =Sheet2!A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ryan" <[email protected]> wrote in message
news:[email protected]...
> I am trying to put the value of one worksheet into another cell in another
> worksheet.

[Max]

> .. will something like this work? =Sheet2!A1

Adding on a little to Paul's suggestion ..
if you need the cell to appear "blank" if Sheet2!A1 is empty
try this variant: =IF(Sheet2!A1="","",Sheet2!A1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[JMB]

Type = then use your mouse to click on the cell in your other worksheet. Hit
Enter.


"Ryan" wrote:

> I am trying to put the value of one worksheet into another cell in another
> worksheet.

[Ryan]

I tried that but for some reason it only works for that one time. Once that
value changes on the other sheet it doesn't change in the current sheet. Got
any ideas?

"Paul B" wrote:

> Ryan, will something like this work? =Sheet2!A1
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Ryan" <[email protected]> wrote in message
> news:[email protected]...
> > I am trying to put the value of one worksheet into another cell in another
> > worksheet.
>
>
> .
>

[Ryan]

Hey man i appreciate it I never thought it would have been that easy.


"JMB" wrote:

> Type = then use your mouse to click on the cell in your other worksheet. Hit
> Enter.
>
>
> "Ryan" wrote:
>
> > I am trying to put the value of one worksheet into another cell in another
> > worksheet.

[Max]

"Ryan" wrote
> I tried that but for some reason it only works
> for that one time. Once that value changes
> on the other sheet it doesn't change in the current sheet.

The above behaviour points strongly
to the calc mode set to "Manual"
(probably inadvertently, and w/o you being aware of it)

To check / change calc mode:
Click Tools > Options > Calculation tab
Ensure "Automatic" is checked > OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[JMB]

You're welcome. Thanks for the feedback.

"Ryan" wrote:

> Hey man i appreciate it I never thought it would have been that easy.
>
>
> "JMB" wrote:
>
> > Type = then use your mouse to click on the cell in your other worksheet. Hit
> > Enter.
> >
> >
> > "Ryan" wrote:
> >
> > > I am trying to put the value of one worksheet into another cell in another
> > > worksheet.