Alternatively the following may help:-

1. In avinity1 type in data (any data that you like) in cells A 6 to E 7
inclusive (10 cells in total - you can make this range any size you like).

2. Highlight the range from number 1. above and do a Ctrl-C to copy.

3. Go to avinity2 Workbook (any cell that you like) then Home group / Paste
/ Paste Link. You should see that the data from avinity1 is copied in. Now,
if you amend avinity1, for the said range, it will update avinity2
automatically.

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.