OK

You've got lotsa help but see where my "typo" question came from........

For example, everytime I type text into cell A20, I want
the exact same thing to cell BL20. The same for B20, BL20, etc.

You refer to BL20 twice. Once for A20 and once for B20.


Gord

On 28 Jun 2006 15:02:22 -0700, wrote:

Hi Gord,

Thanks for the prompt reply. No typo. It's the content that is in
cell A20(yeah it's the first column) that I want to automatically fill
in: BL20. That way I don't have to type it twice. The same for A21
copied to BL21.

Thanks again,

Mike



Gord Dibben wrote:
Looks like a typo in your post.

Perhaps AL20 same as A20?

In AL20 enter =A20

Drag/copy that across to BL20


Gord Dibben MS Excel MVP

On 28 Jun 2006 14:29:38 -0700, wrote:

Hi everyone,

I'm going nuts trying to figure out how to autofill text from one cell
to another. For example, everytime I type text into cell A20, I want
the exact same thing to cell BL20. The same for B20, BL20, etc.

How do I go about that? I already know how to copy formulas from one
cell to another by dragging the skinny black line of the cell. I guess
I just need the formula for a simple IDENTICAL copying of text.

Thanks in advance,

Mike