Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm currently at work trying to begin scheduling employees to begin work. The details are not important but we have 700 employees that need to be scheduled in specific areas. The past people who held my position did everything by hand, and this year I turned it into an excel document because of how often schedules need to change. But now I'd like to be more advanced. The basic setup is all in Excel, and I haven't been able to think/find something that works better. We have 10 different areas that people need to work in.

So what I'd like to be able to do is type someones name into the schedule, and then it automatically go to a different sheet in the same document and have the time they work and where put into the schedule.

I know this sounds very complicated, i've attached a picture that shows the how I would like it to work. Any input would be appreciated.

As a newer member I can't post images but I'd love to share more an example if anyone is curious.

share|improve this question

migrated from stackoverflow.com Apr 7 '11 at 15:29

This question came from our site for professional and enthusiast programmers.

    
I don't see how I'm in violation of faq, I figured that this would be a simple question that I would either be able to see if you all thought it was a possibility or not. I'm a beginning programmer and haven't worked with excel much, so I just thought I'd ask to see if anyone else may know more. –  bchubz Apr 7 '11 at 15:00
1  

2 Answers 2

up vote 1 down vote accepted

You want a relational database. Don't let that scare you, though. Fire up Access. Create tables for Employees and Hours, join them as one-to-many, respectively. Now you just need to define your data fields, slap together an interface with validation, and whip up reports. "Access for dummies" probably has everything you need to know, and I doubt it willl take longer than trying to force Excel to do it.

Added bonus: you won't be beating on nails with a wrench.

(PS: kudos for ditching the pen&paper in the first place!)

share|improve this answer

I assume after you release this excel project all of the managers and co - workers will call it an excel database. This is a database app, don't waste your time trying to code a schedule maker in excel its more headache then its worth. Get an IT professional to write an application to handle this. It is really easy.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.