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