For every question, there's an answer -- and you'll find it here!


Printer-friendly copy
Top The PC Q&A Forum The Computer Forum topic #210464
View in linear mode

Subject: "Database Question" Previous topic | Next topic
_Chewy_Tue Apr-01-03 09:28 PM
Member since Dec 07th 2002
5255 posts
Click to send email to this author Click to send private message to this authorClick to view this author's profileClick to add this author to your buddy list
"Database Question"
Tue Apr-01-03 09:33 PM

  

          

I've got a list of 8-10 candidates that are doing a series of back to back interviews with 7 interviewers. Is there a way using MS Excel to create a master schedule that will auto populate such a table?

9:00 am 9:20 am ........ 5:00 pm
Doctor A: Candidate #1 Candidate #2....... Candidate #8
Doctor B: Candidate #4 Candidate #3....... Candidate #6

Doctor C: Will interview only 5 candidates
Doctor D: ditto

Doctor E: Will interview only 4 candidates
Doctor F: ditto
Doctor G: ditto

  

Alert Printer-friendly copy | | Top

Replies to this topic

SteveYandlTue Apr-01-03 11:46 PM
Charter member
6481 posts
Click to send email to this author Click to send private message to this authorClick to view this author's profileClick to add this author to your buddy list
#1. "RE: Database Question"
In response to _Chewy_ (Reply # 0)


          

Setting up scheduling is probably easier to do with copy and paste operations than to try and set up a macro or get Excel to create the whole set of tables. You certainly don't need to type the list of candidates over and over but writing any sorting schemes would take longer than just moving and shifting columns of names by hand.

  

Alert Printer-friendly copy | | Top

    
_Chewy_Wed Apr-02-03 12:47 AM
Member since Dec 07th 2002
5255 posts
Click to send email to this author Click to send private message to this authorClick to view this author's profileClick to add this author to your buddy list
#2. "RE: Database Question"
In response to SteveYandl (Reply # 1)
Wed Apr-02-03 12:51 AM

  

          

I'm sorry Steve, i didn't quite finish my train of thought there.

The other part of this project is that (after the master schedule is set) we'd like to give each candidate a list of doctors that he/she will be interviewing without throughout the day.

I realize this is not over complicated task and as you point out could be accomplished by copy/paste command. But we have a series of these day-long interviewed coming up in the next few weeks.

There's some other variables that i haven't mentioned because i wanted to keep my post simple. Actually, the secretary that i'm doing this work for is not very knowledgeable in MS Acess/MS Excel and i'm trying to make things easy for her. Just thought there might be an easy way to automate some of the process involved.

  

Alert Printer-friendly copy | | Top

Top The PC Q&A Forum The Computer Forum topic #210464 Previous topic | Next topic
Powered by DCForum+ Version 1.27
Copyright 1997-2003 DCScripts.com
Home
Links
About PCQandA
Link To Us
Support PCQandA
Privacy Policy
In Memoriam
Acceptable Use Policy

Have a question or problem regarding this forum? Check here for the answer.