Hide/show rows with certain column data based on single cell

[cxncxn]

Hi everyone,

I have multiple Excel sheets with the following lay out:

- Standard info till line 23
- Variable rows from line 24 to ... ? (different for each Excel) with 2 important columns, "Type" (= column B) and "Description". After these rows there are a few empty rows (possibility to define end row being empty?)
- The "Type" column has the following possibilities:
1) Basis
2) ARP
3) PSP
4) Extra

Cases:
When cell G21 = 1, I want to hide the lines which have the following data in column B "Type":
Hide "PSP" and "Extra"

When cell G21 = 2, I want to hide the lines which have the following data in column B "Type":
Hide "Extra"

When cell G21 = 3, I want to hide the lines which have the following data in column B "Type":
Hide nothing


Furthermore, I want this to be wrapped in a Worksheet_change and I've heard that screenupdating should be off until everything is done.

Can anyone help me in the right direction? Thank you very much!