dipdog
08-24-2006, 05:31 AM
I have a general question about macros. I've been working with Excel for a little while, and I'm interested in learning more about VBA. There is a project that I've been trying to work on for a while. I've been looking around the internet for a program that would help our work group to schedule their monthly on-call hours. There are only a few formulas that we use. We put 2 of 4 people into 2 different call positions (1st call and 2nd call) every night. Ideally the call positions change every night, except for Fri-Sun during which time they stay the same (ie. same two people in same two call positions Fri-Sun). One of the 4 people only takes call Fri-Sun (no call Mon-Thur). And we try to make the amount of call (weekday call and weekend call) that everyone takes even. I've tried to find a scheduling program that could give us a monthly calendar, allow people to reserve dates that they would not be in the call rotation (ie. vacation), and then evenly assign people to the days that are left. I've been surprised to find that there is very little available to meet these conditions. So I've been considering just trying to write something myself.
Anyhow, my questions is: does this sound like something that would be best suited for an Excel program with VBA macros? Does it sound relatively feasible, or very difficult. And if it does sound feasible, do anyone have any resources that they would suggest for reading up on how to do this.
Appreciate any help you can offer!
- Scott
Anyhow, my questions is: does this sound like something that would be best suited for an Excel program with VBA macros? Does it sound relatively feasible, or very difficult. And if it does sound feasible, do anyone have any resources that they would suggest for reading up on how to do this.
Appreciate any help you can offer!
- Scott