J
J_J
Hi,
I'll try to give as much detail as I can on this problem in order to
increase possible solution alternatives.
In a excel workbook, I have 4 Lists on Sheets 1, 2, 3 and 4 column A:A
respectively.
The list on Sheet1 shows "names of teachers".
The list on Sheet2 shows periods (10 periods for each 5 working day of the
week) that can be used throughout the week e.g (Mon1, Mon2, Mon3,....,
Mon10), (Tue1, Tue2, Tue3, ....,Tue10), .........., (Fri1, Fri2, Fri3, ....,
Fri10) totalling to 50 periods.
The list on Sheet3 shows the lesson names+classes to take it (in the format
lesson_name & " " & class_name)
And the list on Sheet4 shows "Social Activities" of the school.
Assuming we have 10 teachers only,
On Sheet5 I need to have a matrix like table, having all the names of
teachers listed on range A2:A11.
Period label name texts will be shown on row 1 (B1:AY1).
Cell AZ1 will hold the "Social Activities" text, while the AZ2:AZ11 will
have Social Activity input for each teacher.
Range B2:AZ11 will hold data of "lesson_name+classes" info for each teacher,
a blank cell meaning an empty period for that teacher.
So far not so difficult maybe but Here is the hard part for me:
I need to have two report sheets on Sheet6 and Sheet7.
Sheet6 will have a similar layout of Sheet5, only it should have an input
cell to accept a teacher name in order to display the weekly program of the
"selected" teacher only.
Similarly, after inputting the class, Sheet7 will display the weekly program
of that class, but having the involved lesson_name+teacher name as matrix
cell info.
I am looking for a VBA programming solution for this.
Can anyone help me with this?.
Sincerely
J_J
I'll try to give as much detail as I can on this problem in order to
increase possible solution alternatives.
In a excel workbook, I have 4 Lists on Sheets 1, 2, 3 and 4 column A:A
respectively.
The list on Sheet1 shows "names of teachers".
The list on Sheet2 shows periods (10 periods for each 5 working day of the
week) that can be used throughout the week e.g (Mon1, Mon2, Mon3,....,
Mon10), (Tue1, Tue2, Tue3, ....,Tue10), .........., (Fri1, Fri2, Fri3, ....,
Fri10) totalling to 50 periods.
The list on Sheet3 shows the lesson names+classes to take it (in the format
lesson_name & " " & class_name)
And the list on Sheet4 shows "Social Activities" of the school.
Assuming we have 10 teachers only,
On Sheet5 I need to have a matrix like table, having all the names of
teachers listed on range A2:A11.
Period label name texts will be shown on row 1 (B1:AY1).
Cell AZ1 will hold the "Social Activities" text, while the AZ2:AZ11 will
have Social Activity input for each teacher.
Range B2:AZ11 will hold data of "lesson_name+classes" info for each teacher,
a blank cell meaning an empty period for that teacher.
So far not so difficult maybe but Here is the hard part for me:
I need to have two report sheets on Sheet6 and Sheet7.
Sheet6 will have a similar layout of Sheet5, only it should have an input
cell to accept a teacher name in order to display the weekly program of the
"selected" teacher only.
Similarly, after inputting the class, Sheet7 will display the weekly program
of that class, but having the involved lesson_name+teacher name as matrix
cell info.
I am looking for a VBA programming solution for this.
Can anyone help me with this?.
Sincerely
J_J