I am an instructor at a private school. We are creating an excel spreadsheet that we enter information for each student such as homework in each subject and demerits (demerits and things that the students do that they are not supposed to). I already have this page set up the way we need it to print. I need a page to pull from that page. It is already setup also. This 2nd page is a "Homework and Corrective Action" page that we print out and send to the parents to sign. Here is my problem:
I have 40 students. I have a "Data entry worksheet" for each student and a "homework page" for each student. The data entry needs to keep all information listed by days and weeks, but the homework slip only pulls a certain day so we can print and send home and then print again tomorrow. I want 1 place to change which date that all of the homework slips pull from and then when I hit print I want just the homework slps to print.
NOTE: There is also a small data entry worksheet on the first sheet for just general info.
All of this will make more sense once you have seen the file that I have already started.
An example of the file that I have is listed here.