C
Chris Swinney
Hi,
I am a student teacher and am creating a workbook that links my timetable to
class lists, and the individuals in the class to a seating plan, then back
again. Manually linking each cell that refers to a pupil in the class list
to a cell that indicates thier seating position (and back again) is too time
consuming - 30 pupils per class, that 60 manual links.
I thought I could make this somewhat easier by using the Hyperlink function
so I could at least drag a series and part of the lnks would be created for
me. I tried this: -
=HYPERLINK("[Time Table Term 2 (revised).xls]9.1!C5", CONCATENATE('9.1'!B5,"
",'9.1'!C5))
The cell tip/text updates referntially but not the hyperlink valu, so all
the dragged cells in the series still link to C5 on the "9.1" worksheet.
Even if this worked it would only be half the battle. The series above would
be used to create a seating plan from a class list. Each cell could then be
dragged to the required posiiton. However, the original list would still not
link to any of these cells. Is there a simple way to create a second
huperlink from the cell that is refed to above (i.e C5) back to the
originating cell?
This is probably the wrong program to be using for such a task, but I'm not
sure if I can send the time to creat a proper database application.
Chris
I am a student teacher and am creating a workbook that links my timetable to
class lists, and the individuals in the class to a seating plan, then back
again. Manually linking each cell that refers to a pupil in the class list
to a cell that indicates thier seating position (and back again) is too time
consuming - 30 pupils per class, that 60 manual links.
I thought I could make this somewhat easier by using the Hyperlink function
so I could at least drag a series and part of the lnks would be created for
me. I tried this: -
=HYPERLINK("[Time Table Term 2 (revised).xls]9.1!C5", CONCATENATE('9.1'!B5,"
",'9.1'!C5))
The cell tip/text updates referntially but not the hyperlink valu, so all
the dragged cells in the series still link to C5 on the "9.1" worksheet.
Even if this worked it would only be half the battle. The series above would
be used to create a seating plan from a class list. Each cell could then be
dragged to the required posiiton. However, the original list would still not
link to any of these cells. Is there a simple way to create a second
huperlink from the cell that is refed to above (i.e C5) back to the
originating cell?
This is probably the wrong program to be using for such a task, but I'm not
sure if I can send the time to creat a proper database application.
Chris