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

Thanks - Kirk

In C1 of Sheet2

=Sheet1!B1

then drag fill down the column.

--
Regards,
Tom Ogilvy


"kirkm" wrote:


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

Thanks - Kirk

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=

Thanks for that. I couldn't get dmans method to work - it seemed to
reference a column in the same sheet. Tom's method worked but I
can't see how to drag down for 6000 lines.

Can the operation be carried out in code rather than by hand?

However, is this copying the data or displaying it from the other
sheet e.g. is it using twice the space - or does that not matter?

Thanks - Kirk