Feather

AFAIK this cannot be done on entire columns.

Enter the = sign in A1 then switch to other sheet and select A1 and ENTER.

Now just drag/copy that formula down as far as you wish.


Gord Dibben Excel MVP

On Tue, 19 Apr 2005 10:53:02 -0700, Featherstony
wrote:

I am trying to enter data in a column of one worksheet and have the data show
up in another worksheet in the same workbook. I have tried to highlite the
colum and use "=" : highlite the other colum on the other wroksheet and hit
<enter. This does not work. Any suggestions?