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