In Microsoft Excel, how do you mirror a text value in a specific cell to a different worksheet?

Answer 1

Open both worksheets. On the "new" worksheet, click inside the destination cell and type an "=" sign. Then go to the "old" worksheet and click on the cell that contains the value you want to mirror. Go back to the "new" worksheet and press Enter.

Answer 2

1. Type equal to sing in the cell where you would like to mirror
2. Now, click on the worksheet and on the cell where you have the original value.

Hope this helps....

Answer 3

type "=" in the cell of the Different worksheet
go to the original, click on the cell u want
press "Enter" key, and it should have a formula that points to the original worksheet... it will look something like "name of worksheet $A$15"

if u want to be able to drag the values downwards, u have to take out the "$" signs, because that means "point only to that one specific cell".... and if u drag down or across with the $ sign, it will drag down the exact same cell $A$15..... instead, if u get rid of it, it will go down like "A16", "A17", "A18", or across "B15", "C15", "D15"..etc etc....

Answer 4

YOu need to reference it to the other worksheet but both worksheets must be tabs in the same file