Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Time Table Schedule

0

Our's is an academicc department running 3 courses. The requirement is to have an excel (macro-enabled) sheet which can be used to schedule a time table of about 6 periods in a day, 6 days a week. Subject name + Faculty name is to be mentioned. The data can be taken from another sheet which has subject names and faculty names can be in a seperate table sheet or list. 

IF anyone has a solution or suggestion about this issue, do help me.

Vincent

excel
MS Office Version: 2010
posted by: vincyphillips on Thu Nov 7, 2019 at 9:16 am
Answer
Discuss

Discussion

There are two steps to making your list. Step 1 covers the design of the list. Step 2 covers its automation. You find help here for step 2, using either formulas or code. No one can help you with the design because you alone know what you want the sheet to look like. So, please design your sheet. Post a copy here together with a description of what data you wish to appear where under which conditions. That part is your question. Attend to it with the same care as you hope one of us will apply to an answer. Make sure that all the data you wish to appear are already in the sheet. Automation will just display them in different places according to the rules you set. Nobody here will or can invent the rules by which you work.
Variatus (rep: 4889) Nov 13, '19 at 5:57 am
Add to Discussion

Answers

0

day 1  course1 , course2, course3, course1, course2, course 3

day2 see day 1

day 3 to 6 see day 1

I have a sneaky suspicion that there may be a few more requirements to be considered but your current set does not seem to warrant a macro. 

posted by: k1w1sm (rep: 197) on Thu Nov 7, 2019 at 1:50 pm
Discuss

Discussion

Not really what u mentioned... it is something like the following:
                         Period 1   Period 2    Period 3   Period 4   Period 5   Period 6
Mon 
Tue
Wed
Thu
Fri
Sat
This array will be for all the three courses i .e to say... Course 1 Course 2 Course 3

Thanks for your response ...
vincyphillips Nov 8, '19 at 6:19 am
Send me file
beepetark Nov 8, '19 at 12:49 pm
Yes that is exactly what I said  
        period 1 period 2  period 3 period 4  ........ period 6 
Mon  course1 course 2 course 3 course 1....... course 3
What Have I missed?
k1w1sm (rep: 197) Nov 10, '19 at 3:35 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login