How to Auto duplicate cell contents?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mltong - 30 Dec 2005 10:03 GMT

Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells an

I wish them to automatically show in certain cells in other worksheet

(and also may be other workbooks.
I tried to enter =Sheet2!D19 in sheet1 A1 cell. It works fine if
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 show
the old content! It also only show me '0' if I enter the formula befor
I type in any content. And it also just remain '0' even after I entere
text in sheet1 A1. Can someone pls help

Reply to this Message

Bob Phillips - 30 Dec 2005 10:57 GMT

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

Signature

HTH

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

> Suppose if I type 'ABC' in 'A3' & 'DEF' in 'C4' on worksheet1 cells and
>
[quoted text clipped - 7 lines]
> I type in any content. And it also just remain '0' even after I entered
> text in sheet1 A1. Can someone pls help?

Reply to this Message