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