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
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
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks