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