Hide Hundreds of Rows

Its a tool for displaying only some of the rows. Which rows are Filtered to be shown is controlled by the cells in the Criteria range.
The help system has instructions and examples.

Your data needs to be organized with a unique header at the top of each column and no empty rows between data.