I'm trying to hide rows across a multiple sheets. So I have a 6 sheets, but there are 4 similar sheets, the other one is more likely a summary of that 4 sheets and the other one is the sheet with a button. Here's a sample for your reference: LINK
It is working if I will put a HIDE ROWS button on sheets one by one, but it will take a lot of time for me to do it since I need to put it on different spreadsheets. My idea is to put a button per spreadsheet or upon opening it, the rows that are empty will be hidden. The SHOW ROWS button is perfectly working with it.
Here's the script that I'm using: LINK
PROBLEM:
- Hide rows across multiple sheets with similar templates
- Summary sheets rows should be hidden together with 4 sheets (not same rows)
I hope that someone can help me. Thank you in advance!
"MS_Q1", "MS_Q2", "MS_Q3", "MS_Q4"
, the hide rows are the same. Is my understanding correct? And. can I ask you about the detail ofnot same rows
ofSummary sheets rows should be hidden together with 4 sheets (not same rows)
? - Tanaike