Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

TimeTables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bruiser - 20 Jun 2006 02:15 GMT
Ok so basically I'm looking for an easier way to have a school timetable show
up.

essentially, when we are given the list of offered courses we are given both
a timeslot code (1 through 60) and the days/times this code refers to, so i
have a worksheet set up as so

Column Headers: Course Code, Fall/Winter, TimeSlot, (blank), Monday,
Tuesday, ...Friday

And I want to be able to run possibly a script/a function in the
Monday-Friday columns that would allow me to enter any number (between 1 and
60) into the TimeSlot column and have the times come up automatically in the
corresponding day columns with the proper time showing up.

for example ECON 390 is time slot 45, which is monday 10:00 and wednesday
11:30...

I want an easy (and efficient way...by efficient i mean type out the script
once, and then just hack away these timeslots) way to be able to input "ECON
390" in Course Code, "Fall" from the drop down in Fall/Winter, and then put
"45" in Time Slot...under each day the appropriate times would show up
without having to type anything....

is there any way, in Excel XP or 2003 Professional edition to do this, which
may be LESS time consuming than actually manually typing the times in?

Thanks
David McRitchie - 20 Jun 2006 04:21 GMT
Hi "Bruiser",
See use of VLOOKUP  you want to use False for an Exact match
 http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> Ok so basically I'm looking for an easier way to have a school timetable show
> up.
[quoted text clipped - 24 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.