Similarly, you may select cell B2 and drag the fill handle down to copy the formula ... data from one Excel sheet to another is to use cell references, where you directly link cells from the ...

Next, select a section by dragging over the area of data and hit ‘Copy ... ‘Paste link’ under ‘Paste Special’ heading, and then, under ‘As’, select Microsoft Excel Worksheet ...