Links or HLOOKUP

[Chi]

Hi,
I entered numbers from A4:N15 in sheet named CLASS. I would like to have
these numbers appear on STUDENT sheet which is in different workbook.

Please show me how.

May I use HLOOKUP function? Or what function I should use?
Thanks
Chi

 

[Vito]

in A4 of your Student workbook enter,

=[CLASS.xls]Sheet1!A4, replacing Sheet1 with the actual sheet name, i
different.

Then copy this across to N4 and then down to N14