Condesning/Automating Nested If statements

Hello! I am a novice with VBA, so I need some assistance. I have manually entered a large nested If statement in my VBA. The overview is that I would like to create passwords (which can be found in a hidden column and also happen to be the users first name) that users must enter and click a button (which runs this macro) in order view the cells that "belong" to them. Passwords are simply their names, which can be found in column Q, starting in row 4. If the user enters their name (aka password), I would like it to check against Column B, which also has their name in it. The macro should unhide all the rows that have their name/password in column B. Here is my large and obnoxious VBA that needs to be automated/cleaned up. An example is that the password "Chris" should reveal rows 21-25 only.

Please Login or Register  to view this content.

I suppose that what I would prefer to do is be able to have the "passwords" come from a list in column Q, and search for that same password in column B. Then, if the password they entered is in B, it will make all the rows that have it visible. This way I won't have to manually enter the passwords and choose the new rows for them to reveal if I end up changing the passwords/ranges at all in the future.

Hi !

With this column Q you may use an advanced filter to create the unique passwords list
and with the worksheet MATCH function or Range.Find method in order to check a password
then filter the rows (or just directly filter the rows accordingly).

With a workbook sample and a clear & complete explanation it would be easier for helpers …

This is very helpful for condensing it, but is there a way that I am able to use cell references for the passwords? Then use those passwords to check against column B and unhide any rows where the password shows up in column B?