scheduling

[jerryo1314]

Hi,
I have a need for scheduling. This would be to schedule parent conferences on a 5 minute bases on a given day. 6th grade IE: Jonny's Mom will see teacher A @ 2:15,teacher B @ 2:30 and teacher C @ 2:45. Now I have 725 little Jonny students to see 60 teachers in 5 minute intervales. Can you get me started scheduling ? It would be nice if there was a yes default incase mom doesn't want to see every teacher.
Jerry
I need a few secrets to get started.

 

[jerryo1314]

Oh Boy,
We worked on this making the sample chart.
We then attempted the SchedManager in vbe but got confused. We have little knowledge of macros. Do I dare ask for more guidance ? We did copy and paste the Sched-Manager into vbe but it said book4. No way to "save as" How do you run it, if it's in the right place ? I know it's a macro but how does it start?
My School is Macintosh and Appleworks however I did install Office 2001 for the Mac and we are all learning.
I know this was a massive project for you and I'm very grateful, as will be the secretaries.
Jerry

 

[jerryo1314]

remove body
This message was edited by jerryo1314 on 2002-12-22 11:44

 

[tusharm]

Check the foll.:

Getting Started with Macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Excel for Windows Visual Basic for Applications 101
http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/default.asp

Install a Macro or User Defined Function
http://www.mvps.org/dmcritchie/excel/formula.htm#install

While all the examples above refer to a Wintel environment, the same concepts apply to a Mac. The keyboard shortcuts might be different, but the menu items should be the same.

Alternatively, I can send you the workbook I used for building the code.

 

[jerryo1314]

Tushar,
Well it was running all along but I didn't notice it was over writing.
Not sure I can sort this time frame being so many columns wide ? The teacher or who ever would have to look all over for the next time frame.
This message was edited by jerryo1314 on 2002-12-22 11:48