timetable

Hi there, I am completely new to excel and I was unaware of the extent of its functions. I have been tasked with converting the layout of a cinema timetable that is in a spreadsheet. the timetable also includes the age rating of the movie and the director . I am also not going to include certain...

Good Day, I work in Public Transport planning, we compile our time tables (origin + origin time and destination + destination time on a specific route / path) in Ms. Excel. Once the timetable is completed it looks something like this: https://ibb.co/ccNzSNB You will notice that the...

hello I'm looking for ideas for a weekly timetable to my company. timetable is edited every week, there are 5 workers, each one of them has own line colour, I made a hourly grid where his colour showed his avaliability but in my opinion it becomes chaotic. Next, filled in colours table goes...

Hello, I keep spending lots of time trying to solve this problem, and altrough not there I have learn some Excel in the way ... but not enough, so I hope someone can help me out.. Here it goes: I have an Excel 2016 workbook with several worksheets with my School classes...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hi all, I would like to create a vba code so that to transfer the data from employees finger file to staff timetable base on employees’ code so that where is matching, should...

Hi All, I have an excel file for pupil timetables. In cell "C1" i have a dropdown menu which changes to each pupil name. Below this is the pupils timetable for the week. I have created a macro that automatically changes the dropdown to the next pupil and then prints the pupil timetable, then...

Hello Everyone, I am a teacher and my school timetable changes weekly. I am trying to write a formula to check that my timetable does not clash with other classes. I teach accounting. There is a master timetable with all the subjects for one group of students, then the subject timetable are...

Hello, I have a timetable, I am looking to be able to merge the cells of how long a class is running for. This is my range, Set rngMerge = Range("C3:L11") 'Set the range limits here The timetable is very basic, 9 9:30 10 10:30 11 etc... Mon Tue Wed Thur Fri I currently have the...

Hello Forum! I was wondering if you could help me with a little problem I am having. I have an Agenda sheet for the days of the week, and a Schedule timetable sheet. Basically I have a dropdown of a start time for a certain module on the agenda sheet (Day1 B:10) it currently checks the value of...

Hello All, this is my first post, so apologies if I come across noob-ish! What I am trying to do is compare 'Prices' between different 'Providers' for 'Trips' that they all run/operate - Public Transport for instance. The raw data might look something like this if simplified: <tbody> Provider...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi, I have a master timetable for interviews which involves 6 assessors and 6 candidates showing the room, the activity, the assessor and the candidate at a particular time. What I would like is the ability to take the master timetable and automatically be able to generate 12 personal...

I need help with this one, I am new to VBA and cannot figure out how to do this. I am using Excel 2007. What I need to do is take data from this table and have it generate a timetable. <table border="0" cellpadding="0" cellspacing="0" width="507"><col style="width: 107pt;" width="142">...