Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TimeTables
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 "Bruiser" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
school or college timetables? | Excel Discussion (Misc queries) | |||
WHAT TYPE OF TIMETABLES ARE THERE | Excel Worksheet Functions |