Hide rows in a sheet according to selections on another sheet

Hello! I am new to VBA and I'd like to ask for some help.

In sheet 1, there are several options that one can choose (A, B, C and D). More than one option can be choosen.

After that, I would like that in sheet2, only the choices made in sheet1 appear in sheet 2 (i.e. the ones that were not chosen should be hidden).
Row 4 should always be visible.


Also, the sheet should be protected, so this part of the code should always be present:

Please Login or Register  to view this content.

Thank you very much and Wishes of a Good New Year!

1 way to do

Please Login or Register  to view this content.