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