R
Rafi
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
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