I need current value of one worksheet into another cell?

P

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
 
M

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)
 
R

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?
 
M

Max

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.
Click to expand...

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
 
Top