Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking many cells
I wish to link many cells in (e.g. A1:40) in sheet 1 to A1:A40 in sheet 2
without doing it one by one so that whaever I type in A1 sheet 1 appears in A1 sheet 2. Please any idea? dk |
#2
|
|||
|
|||
Linking many cells
As long as your 'from' and 'to' blocks are structured identically (eg 1
column of forty rows in your example), it's straightforward. Click in the first 'to' cell, Sheet1!A1. Type the '=' sign, then click in the first 'from' cell, Sheet2!A1, then hit enter. Your formula in Sheet!A1 should read =Sheet2!A1 (look for it in the formula bar). Grab the fill handle (the extreme lower right corner of the cell) and drag it down ('autofill') until it fills the rest of the 'to' block. "dk" wrote: I wish to link many cells in (e.g. A1:40) in sheet 1 to A1:A40 in sheet 2 without doing it one by one so that whaever I type in A1 sheet 1 appears in A1 sheet 2. Please any idea? dk |
#3
|
|||
|
|||
Linking many cells
Thanks.
regards, dk "dk" wrote: I wish to link many cells in (e.g. A1:40) in sheet 1 to A1:A40 in sheet 2 without doing it one by one so that whaever I type in A1 sheet 1 appears in A1 sheet 2. Please any idea? dk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use functions when cells are merged | Excel Worksheet Functions | |||
Linking cells | Excel Worksheet Functions | |||
linking cells and assort decending | Excel Discussion (Misc queries) | |||
Excel - linking cells | Excel Worksheet Functions | |||
Linking Non-Contiguous cells | Excel Discussion (Misc queries) |