software

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 amp; 2003

quot;Ryanquot; gt; wrote in message
...
gt; I am trying to put the value of one worksheet into another cell in another
gt; worksheet.
gt; .. will something like this work? =Sheet2!A1

Adding on a little to Paul's suggestion ..
if you need the cell to appear quot;blankquot; if Sheet2!A1 is empty
try this variant: =IF(Sheet2!A1=quot;quot;,quot;quot;,Sheet2!A1)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
Type = then use your mouse to click on the cell in your other worksheet. Hit
Enter.quot;Ryanquot; wrote:

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

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?

quot;Paul Bquot; wrote:

gt; Ryan, will something like this work? =Sheet2!A1
gt;
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Ryanquot; gt; wrote in message
gt; ...
gt; gt; I am trying to put the value of one worksheet into another cell in another
gt; gt; worksheet.
gt;
gt;
gt; .
gt;

Hey man i appreciate it I never thought it would have been that easy.quot;JMBquot; wrote:

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

quot;Ryanquot; wrote
gt; I tried that but for some reason it only works
gt; for that one time. Once that value changes
gt; on the other sheet it doesn't change in the current sheet.

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

To check / change calc mode:
Click Tools gt; Options gt; Calculation tab
Ensure quot;Automaticquot; is checked gt; OK
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
You're welcome. Thanks for the feedback.

quot;Ryanquot; wrote:

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