How to Auto duplicate cell contents?

M

mltong

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula referencing cells 4
Copy cell formula returns zero instead of cell value 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
format changes when copying from one cell to another 2
duplicate cells linearly? 2
Find and Highlight 4
Work around Conditional Formatting 3
3 challenges; concequences of activating cell + 2 text formulaproblems 2

Top