linking a range of cells (=) to another range
1. In EXCEL 2007 Set up 2 Workbooks one called avinity1.xlsx the other called
avinity2.xlsx.
2. In avinity1 Workbook in cell A 1 type, for example, this is cell A1.
3. Go to avinity2 Workbook and in cell A1 type:-
=[avinity1.xlsx]Sheet1!$A$1
This will copy the information directly from the avinity1 Workbook.
There are other ways of doing this.
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.
|