Is there a way to have (i.e.) column B in sheet 1 to transfer automatically to column B in sheet 2?
T Terri May 10, 2005 #1 Is there a way to have (i.e.) column B in sheet 1 to transfer automatically to column B in sheet 2?
G Gord Dibben May 10, 2005 #2 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. Edit>Paste Special>Paste Link>OK>Esc. Gord Dibben Excel MVP
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. Edit>Paste Special>Paste Link>OK>Esc. Gord Dibben Excel MVP
