Dianne

Assuming you enter data in A1.........

In B1 enter this formula =A1

If not what you were looking for, remember this...a formula can only return a
value to the cell in which it is written.

You can enter data in a cell and have it show up somewhere else by using VBA.


Gord Dibben Excel MVP

On Mon, 15 Aug 2005 09:38:51 -0700, Dianne
wrote:

I need the information that is entered in the cell to automatically fill into
other selected cells.