Type data in one cell - and it automatically populates another cel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 17 Mar 2007 00:08 GMT

I'm looking for a formula (I think a formula, or some other way) whereby I
enter data in one cell on one worksheet and it simultaneously (or after a
keystroke or two) fills in the same data in a cell that I select on another
worksheet, all within the same workbook. E.g., I type in the name "Roger" in
cell C3 on sheet 1. I would have previously set up a condition in a formula
or some other way whereby anything I type in cell C3 of sheet 1 is repeated
in cell D4 of sheet 2. In other words, Excel does the "copying" on-the-fly
using my pre-determined cells, i.e., anything I type in C3 is automatically
filled in D4 of another sheet I specify.

Signature

Tom

Reply to this Message

Gord Dibben - 17 Mar 2007 00:20 GMT

Tom

In D4 of sheet2 enter =Sheet1!C3

Another way is to enter an = sign in D4 then switch to sheet1 and select C3 and
hit ENTER key.

And one more...........select C3 and switch to sheet2, select D4 and Edit>Paste
Special>Paste Link>OK>Esc.

In all cases, D4 will get the above formula.

Gord Dibben MS Excel MVP

>I'm looking for a formula (I think a formula, or some other way) whereby I
>enter data in one cell on one worksheet and it simultaneously (or after a
[quoted text clipped - 5 lines]
>using my pre-determined cells, i.e., anything I type in C3 is automatically
>filled in D4 of another sheet I specify.

Reply to this Message

Anne Troy - 17 Mar 2007 04:19 GMT

To add to what Gord said, I often do something like this:
=if(isblank(Sheet1!C3),"",Sheet1!C3)
That way, you won't get a 0 in the cell in which the formula resides when
Sheet1!C3 is blank.

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

> Tom
>
[quoted text clipped - 27 lines]
>>automatically
>>filled in D4 of another sheet I specify.

Reply to this Message

Gord Dibben - 17 Mar 2007 05:20 GMT

Thanks Anne.

I too often forget about warning posters of the zero issue and giving them a fix
as you have done.

Only drawback is a straight "paste links" won't add the error trap so you have
to build the first formula from scratch then copy.

Gord

>To add to what Gord said, I often do something like this:
>=if(isblank(Sheet1!C3),"",Sheet1!C3)
[quoted text clipped - 37 lines]
>>>automatically
>>>filled in D4 of another sheet I specify.

Reply to this Message

Anne Troy - 18 Mar 2007 02:49 GMT

Were you in Seattle? If yes, I'm so sorry I missed you.
I had a unique opportunity to crash and met so many others.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************

> Thanks Anne.
>
[quoted text clipped - 52 lines]
>>>>automatically
>>>>filled in D4 of another sheet I specify.

Reply to this Message

Gord Dibben - 18 Mar 2007 05:21 GMT

Couldn't make it this year.

Perhaps another time?

Gord

>:)
>Were you in Seattle? If yes, I'm so sorry I missed you.
[quoted text clipped - 60 lines]
>>>>>automatically
>>>>>filled in D4 of another sheet I specify.

Reply to this Message