funtion help

I am using excel 2000, and when I add text to a cell I would like it to also be added to another cell on another page. I tried the T(value) function but that only works for numbers.

I use Excel 2003 so see if it works on 2000 as well.

Go to the cell that you want the text copied into. Insert the following formula-

=WORKBOOK NAME!CELLNO

Replace WORKBOOK NAME with the title of the workbook that has the original text you want copied. The name should be identical to the name on the tab at the bottom.

Replace CELLNO with the cell reference containing the text that needs to be copied.

Dont forget the ! between the name and cell number.

Hope this helps

Originally Posted by jziggy

I am using excel 2000, and when I add text to a cell I would like it to also be added to another cell on another page. I tried the T(value) function but that only works for numbers.

=Sheet1!A1