In , kirkm
spake thusly:

Is it possible to have a column in Sheet2 duplicate a column of
data that exists in e.g. Sheet1 ?

On Sheet2 in the top cell in the column, type an equals
sign. Now navigate to Sheet1 and click on the top cell in
the relevant column there. Now you will have a reference
on Sheet2 to that cell in Sheet1. Drag the formula down.

=dman=