I need to hide certain rows in a sheet so it would seem like there's no data to show

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.

Obviously 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 and show rows, but not from the user seeing the sheet but from any 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.

Any help would be greatly appreciated.

Originally Posted by AskMeAboutExcel

What version of Excel are you using?

Many different approaches, but the easiest is using PowerQuery to create a filtered version of your table and mapping your App to this.

Hi, thank you for your answer.
I'm using Office 2021.

I'll have to look into PowerQuery, never use it before.