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

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" wrote in message
...
I am trying to put the value of one worksheet into another cell in another
worksheet.

.. 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
---

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" wrote in message
...
I am trying to put the value of one worksheet into another cell in another
worksheet.


.

"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
---

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.

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.

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.