How to Auto duplicate cell contents?

Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells and
I wish them to automatically show in certain cells in other worksheets
(and also may be other workbooks.
I tried to enter =Sheet2!D19 in sheet1 A1 cell. It works fine if I had contents in sheet2 d19. But if I changed the contents in Sheet2 D19. The content in sheet1 A1 doesn't change to new content. It still shows the old content! It also only show me '0' if I enter the formula before I type in any content. And it also just remain '0' even after I entered text in sheet1 A1. Can someone pls help?

Do you have manual calculation set? Check Tools>Options>Calculation, and
ensure the Automatic button is set.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mltong" <mltong.20ulam_1135937401.1224@excelforum-nospam.com> wrote in
message news:mltong.20ulam_1135937401.1224@excelforum-nospam.com...
>
> Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells and
>
> I wish them to automatically show in certain cells in other worksheets
>
> (and also may be other workbooks.
> I tried to enter =Sheet2!D19 in sheet1 A1 cell. It works fine if I
> had contents in sheet2 d19. But if I changed the contents in Sheet2 D19.
> The content in sheet1 A1 doesn't change to new content. It still shows
> the old content! It also only show me '0' if I enter the formula before
> I type in any content. And it also just remain '0' even after I entered
> text in sheet1 A1. Can someone pls help?
>
>
> --
> mltong
> ------------------------------------------------------------------------
> mltong's Profile:
http://www.excelforum.com/member.php...o&userid=30001
> View this thread: http://www.excelforum.com/showthread...hreadid=496894
>