Hello Forum
I have the following Table, it is to organize private classes.
Classify the students by Name (by colors I did not know how to achieve it) and € / Hours
I have the other table that is Week and where depending on the time I indicate the name and knowing the price (€ / h), it tells me some values per day, hours and even totals in that week.
My doubt is that I would like to be able to change the number of the weeks automatically but that I respect when returning to previous weeks the schedules with their letters.
For example
If I have a total of 30 weeks
If I write 4 then I would see the classes of Week 4 (for example: 5h Pablo, 4h Fernando, 13h Cristina)
If I write 6 then I would see the classes of Week 6 (for example: 3h Fernando, 3h Cristina)
Can anybody help me?
Thank you.View attachment TABLA HORARIOS.xlsx
I have the following Table, it is to organize private classes.
Classify the students by Name (by colors I did not know how to achieve it) and € / Hours
I have the other table that is Week and where depending on the time I indicate the name and knowing the price (€ / h), it tells me some values per day, hours and even totals in that week.
My doubt is that I would like to be able to change the number of the weeks automatically but that I respect when returning to previous weeks the schedules with their letters.
For example
If I have a total of 30 weeks
If I write 4 then I would see the classes of Week 4 (for example: 5h Pablo, 4h Fernando, 13h Cristina)
If I write 6 then I would see the classes of Week 6 (for example: 3h Fernando, 3h Cristina)
Can anybody help me?
Thank you.View attachment TABLA HORARIOS.xlsx