Links or HLOOKUP
 

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

Links or HLOOKUP
 

in A4 of your Student workbook enter,

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

Then copy this across to N4 and then down to N14.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=493895