RichardMichael
New member
- Joined
- Jun 29, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I want to create data input forms for a college schedule
Data would be grouped as follows:
I want to be able to input data using a form but to be able to include data from a range of cells. For example, A class might be programmed for three separate days in one week or two days per week, etc.
There are likely to be constant changes to the schedule so I want to be able to easily move data around in groups without having to type each entry separately in each cell every time stuff needs to be moved.
I also want to be able to filter a view data to show the following separately:
Start and finish dates
Programme content
Courses per week
Subjects per days, weeks
Student allocations
Teacher allocations
Duplications
Ideally, I would like to be able to do all of this through the same form.
I also want to lock cell formatting on the sheet. In other words, data would be moved but the template design, row/column shading, borders, etc would remain unchanged as data was moved from one place to another.
Basically, I am using excel to do the job of a proprietary scheduling software, due to the fact that the institution is unable/unwilling to assign a budget to this area.
Data would be grouped as follows:
Semester
| |
I want to be able to input data using a form but to be able to include data from a range of cells. For example, A class might be programmed for three separate days in one week or two days per week, etc.
There are likely to be constant changes to the schedule so I want to be able to easily move data around in groups without having to type each entry separately in each cell every time stuff needs to be moved.
I also want to be able to filter a view data to show the following separately:
Start and finish dates
Programme content
Courses per week
Subjects per days, weeks
Student allocations
Teacher allocations
Duplications
Ideally, I would like to be able to do all of this through the same form.
I also want to lock cell formatting on the sheet. In other words, data would be moved but the template design, row/column shading, borders, etc would remain unchanged as data was moved from one place to another.
Basically, I am using excel to do the job of a proprietary scheduling software, due to the fact that the institution is unable/unwilling to assign a budget to this area.