Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking contents of multiple cells to an external object
Hope I'm posting to the right forum. If not could someone please tell me where the appropriate place is. I've coded in Excel a register for a small college that allows the user to enter whether a student attended a particular subject. Each worksheet shows the whole class for a month, with students as rows & dates as columns & the subject appears in the cell. Totals appear on a seperate sheet. Where a student is absent there are a few alternative codes & on a seperate line room for a short comment. What is required is to automatically pull out the abscences on a separate sheet (Word or Excel) unique to the student. I can see how to copy the contents of a cell as a linked object but how do I associate it with 2 or 3 cells: eg let us say the date is in Row 2 & Student A is Row 6. On the 14th (column J) he is absent. So in J6 an "a" for absent goes in. I need to link J2 (the date), J6 (the absence) & J7 (the comment) & put them say in a Word document. Trust this is clear. Not sure if one can send an xls attachement to teh forum to illustrate this better, but can allways send as direct email. Thanks for any suggestions -- Rafi ------------------------------------------------------------------------ Rafi's Profile: http://www.excelforum.com/member.php...o&userid=26785 View this thread: http://www.excelforum.com/showthread...hreadid=400399 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding separate accumulators for multiple cells | New Users to Excel | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
selecting multiple cells with ctrl key | Charts and Charting in Excel | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
background formatting across multiple cells | Excel Discussion (Misc queries) |