Formulas cannot "send" data anywhere.

In A2, A3 and A4 you must have formulas linking to A1 by =A1

But if you overwrite the formula in A3, it no longer is a formula and A4 is
still linked to A1 so can't return what you typed in A3

What you want to occur can only be done through VBA code


Gord Dibben MS Excel MVP

On Thu, 5 Mar 2009 11:51:02 -0800, Maria
wrote:

Sorry if this is posted twice-

I would like to have data from one cell get sent to another cell in the same
worksheet. But I don't want to put a formula in the second cell to grab that
data from the first cell. Is this possible?

For example, if I type in my first name in A1, I would like it to
automatically appear in cells A2, A3, and A4. However, I would like to have
the flexibility to type in my last name into A3 and have that then
automatically appear in A4 as well.

Thanks for your time,
Maria