I use a Google-Sheet (sheet called "Data") for my payroll. In A1 I paste data from another spreadsheet that I use to store all the data for my business ( example value of job, location, date, subcontractor name ) There are 600 rows total in the sheet called Data
In my payroll Google-Sheet I have an additional sheet for each subcontractor that works for me. These are meant to be statements that I can print with their checks. Each of these sheets also have 600 rows, and each element ( still talking about the subcontractor's shets ): A1, A2 ..., B1, B2, ...is a reference to the same A1, A2, ..., B1, B2, ... in the sheet called Data.
All I have to do in each of the subcontractor-sheets is filter by name & Wala! it is ready to be printed.
For example: Let's say I filter a subcontractor-sheet for my name Xzila. Of the 600 rows only 7 are for Xzila. I then click on print, but now it is printing like 30 pages because it is including the other 593 rows I filtered out.
TLDR: How to use the google-sheets filter to hide rows and then print the sheet such that it does not print those filtered rows.
Attempts:
- To actually make the rows hidden ( this works but it is very tedius and defeats the time saving purpose )
- Use a google-script to hide each row one at a time ( this takes a reaaaaaaly long time )
- export Google-Sheet to an excel spread sheet and the print. ( this works, but it loses a lot of formating and forgets that some numbers are currency and some numbers are dates )