filling information from one cell and filling another.

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 <Dianne@discussions.microsoft.com>
wrote:

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

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 <Dianne@discussions.microsoft.com>
wrote:

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

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 <Dianne@discussions.microsoft.com>
wrote:

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

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 <Dianne@discussions.microsoft.com>
wrote:

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

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

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 <Dianne@discussions.microsoft.com>
wrote:

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