updating of worksheet against info from another worksheet
 

hi all, good day.

i've a 2 worksheets, 05_S2 and StudGrp_BU. the first worksheet is the
schedule of complementary studies (CS) modules and the second is the
block time sheet for student groups.

what i need here is to be able to click on the button in the block time
sheet and update the block time against the CS schedule.

in the sample, i've Mon, 0800-0950 for PROGRAM1 EI students on the
schedule, hence in the block time sheet, under "Day 1 (Mon)
Practical/Tutorial", "0800-0850" and "0900-0950", and the student group
"ITDF04PROGRAM1EI101" and "ITDF04PROGRAM1EI102", the time slots will be
set to "1" where you can see the blocked time slots are in red.

because in my actual worksheets, i've much more datas where i actually
have 7 PROGRAM1 EI groups and hence have 7 CS classes. i know i need
arrays and loops to keep checking for the values to update. but my
coding doesn't seem to work. i hope my explanations are clear enough to
understand. my sample is zipped because it is 59+kb and that is the best
and least i can compile not leaving the important out. i hope you all
can help me with it. Thank you very much.

i've also attached a sample of my desired results.


+-------------------------------------------------------------------+
|Filename: Desired result.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4254 |
+-------------------------------------------------------------------+

--
tandavina
------------------------------------------------------------------------
tandavina's Profile: http://www.excelforum.com/member.php...o&userid=30334
View this thread: http://www.excelforum.com/showthread...hreadid=503755