This is what you need in cells H 20 to H 23:-

=Sheet1!C34
=Sheet1!D34
=Sheet1!E34
=Sheet1!F34

If my comments have helped please hit Yes.

Thanks.



"wilhelmus" wrote:

How do I link a range of cells in a column on one worksheet to a range of
cells on a line in another worksheet.
E.g: the data appearing in 'sheet 1' is on range C34: F34.
I would like to see these contents automatically appear in 'sheet 2' on
range H20:H23.