Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruiser
 
Posts: n/a
Default TimeTables

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
school or college timetables? einsteinjrp Excel Discussion (Misc queries) 1 May 25th 05 12:16 PM
WHAT TYPE OF TIMETABLES ARE THERE Technician timetable Excel Worksheet Functions 0 May 11th 05 10:48 AM


All times are GMT +1. The time now is 12:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"