linkng one cell to another-so they display the same thing.

[fugu2002]

im sruglling to find the formula,

i have one cell on one page. when i type something in this cell, how do i get it so that the text i have written is displayed in another cell on a different form?


please help me. please

[swatsp0p]

Your formula on Sheet2 would look like this to show data from Sheet1:

=Sheet1!A1

Of course, adjust sheet name and cell reference to meet your needs. The key is the '!' after the name of the sheet you are referring to.

HTH

Bruce