Printing issue

Hi!

I hope someone can help me with a “printing related” issue.

To start with: In my company I have several different jobs/projects where I perform different kind of services. These services are performed with different intervals like every week, every month and so on.
I wanted to make a big sheet where every job has its own page. So when I pres “print” I get one page for each job/project. See attachment 1 where I have made a quick draft. If I only want to print out job 1 and 3 I simply sort out job 2 and I get one page with job 1 and one page with job 2.
But the problem is when I want to see only a certain kind of activities. This is showed in attachment 2 where I have filtered out some activities. When I press “print” some of job 2 I suddenly on the first page.

I am not an experienced excel user (as you probably can see from my draft) so I have two questions.

1. Does anyone have a solution to my problem as explained above?
2. Does anyone have a whole different solution to my case, but with the same filtering possibilities?

Espen