Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic transfers
Is there a way to have (i.e.) column B in sheet 1 to transfer automatically
to column B in sheet 2? |
#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. 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off automatic date formatting? | Excel Discussion (Misc queries) | |||
How do I switch off automatic formatting (e.g. dates)? | Excel Discussion (Misc queries) | |||
find automatic page breaks | Excel Worksheet Functions | |||
Automatic backup copy | Charts and Charting in Excel | |||
Automatic Links | Excel Discussion (Misc queries) |