I would like that when I put in a word in a cell, it would automaticaly go in
another cell or even on another page without having to type it in every time.
I enter a lot of same data in cells.

If you type your text into cell A1, then the other cells (on the same sheet)
should have a formula like =A1. A cell on the other sheet needs to put the
sheet name of the cell you're typing in first, like =Sheet1!A1. If the sheet
name has spaces or other funky characters, enclose it in single quotes like
this: ='My Work Sheet'!A1.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gazelle" wrote in message
...
I would like that when I put in a word in a cell, it would automaticaly go
in
another cell or even on another page without having to type it in every
time.
I enter a lot of same data in cells.

just type in = then the cell reference you are referring to.

So if you are entering the word in cell A1, type =A1 in the cell where
you want to duplicate it

Tony

Gazelle wrote:
I would like that when I put in a word in a cell, it would automaticaly go in
another cell or even on another page without having to type it in every time.
I enter a lot of same data in cells.