Is there a way to hide or deactivate rows?

[rohnn]

Hi everybody.

I have a an app that pulls information dynamically from an excel sheet.

In this sheet, in each row, I have available cars for renting. And the apps pulls all necessary information from the sheet and presents it to the user. The thing is that the data is always changing and I don't want to keep erasing and writing back cars that are available for rent or not.

So what I'm looking for is for a way to hide or "deactivate" rows, but not from anyone working on the sheet, but from the script that it's trying to pull information from the sheet, so it would be like there's no data in some rows.

I saw a sheet that had a "active" column, with a TRUE or FALSE value, so that I could mark each row as active(TRUE) or not active (FALSE), but unfortunately it was just a screenshot and I couldn't see how it worked. 2023-02-02-10-23-53-Copy-of-Google-Sheets-Template-for-Pizza-Ordering-and-Delivery-Messenger-Bot-G hosted at ImgBB

Any help would be greatly appreciated. Thanks.

 

[Micron]

If you have a "flag" value in a column (could be whatever you want but I'd suggest 0 for False and -1 for True). 2 examples
If the row contains 0 it will not hide (Hidden = 0 = False, not hidden). If the row contains -1 it will be hidden.

Sheets("4").Rows(10).EntireRow.Hidden = Sheets("4").Range("B10")

so the hiding code line can be that simple.

If the flag value is something else, then

If Sheets("4").Range("B9") = "YourFlagValueGoesHere" Then
   Sheets("4").Rows(9).EntireRow.Hidden = True
End If

Of course that is just a simple answer to your question. To restore hidden rows, you could just select the whole sheet via top left sheet selector, right click and choose unhide from the context menu. I used row values 9 and 10 to test but you would want to loop over all the rows in a particular column that would contain your flag value.

 

[rohnn]

If you have a "flag" value in a column (could be whatever you want but I'd suggest 0 for False and -1 for True). 2 examples
If the row contains 0 it will not hide (Hidden = 0 = False, not hidden). If the row contains -1 it will be hidden.

Sheets("4").Rows(10).EntireRow.Hidden = Sheets("4").Range("B10")

so the hiding code line can be that simple.

If the flag value is something else, then

If Sheets("4").Range("B9") = "YourFlagValueGoesHere" Then
   Sheets("4").Rows(9).EntireRow.Hidden = True
End If

Of course that is just a simple answer to your question. To restore hidden rows, you could just select the whole sheet via top left sheet selector, right click and choose unhide from the context menu. I used row values 9 and 10 to test but you would want to loop over all the rows in a particular column that would contain your flag value.

Thank you! I will try that.