you can download an example here:
https://docs.google.com/leaf?id=0B5piylDHt3ybOGNlOGUzMDMtNDEyZS00NWJiLThjNzAtNGZkZTIwZTIyYWMw&hl=en_US&authkey=CNGl-v0D
Ok I'll write it now:
In Sheet1 you have your database of filtered data, of which you only want to print the top 5 rows. Let's assume your database uses only 3 columns, A B and C. In column D you will put the value 1 in every cell. In column E you put the subtotal sum of each cell on it's...
You can export that data into a second sheet, like a "Reporting sheet".
Using subtotal formula and a couple of helping columns, you can know what cells are visible and link only the top 5 rows to this "Reporting Sheet", that you print using a A3:A8 type print range.
I did this and I can...