Terri

Select B1 in sheet2.

Enter an = sign.

Switch to sheet1 B1 and hit ENTER key.

Drag/copy sheet2 B1 down as far as you have data in sheet1 column B

Alternative..........

Select sheet1 B1 then hit SHIFT + End + Downarrow

Copy.

Switch to sheet2 B1.

EditPaste SpecialPaste LinkOKEsc.


Gord Dibben Excel MVP

On Tue, 10 May 2005 09:31:07 -0700, "Terri"
wrote:

Is there a way to have (i.e.) column B in sheet 1 to transfer automatically
to column B in sheet 2?