First unhide all rows - then hide rows based on specific cell value for a range of cells

Hi All,

This is my first post so I hope I explain myself accurately. Any help I can get on this would be GREATLY appreciated, as I have researched this topic for about two hours and am still unable to find a good solution to my specific situation. Here's what I'm looking for:

First, I want this macro to run only on the "RD Summary" sheet, not the entire workbook. Then, I want to unhide all rows on the worksheet. Then, I want to hide any rows in column B within the range of b25 to B400, if the cell value in column B is "n/a". Also, I'm not sure if this matters, but the cell values are all formulas.

Please let me know if you have any suggestions for this. I REALLY appreciate your help - this could save me so much time!!!

Hi Winon,

Thanks for your quick response. I can't upload the specific workbook I'm going to use this on because it has personal/private information on it. However, I attached a sheet here that's a very watered down version of what I'll be using this for. Does this help?? BD Summary Report.xlsx

Thanks again,
Robbie

Hi Winon,

Just replying to see if you saw my attachment and if it's helpful, or what other information would help solve this issue. Thanks!

Robbie

Hi Winon,

Yes, this does exactly what I want it to do!! I also like how you set up the button, but the only problem is that I can't figure out how to get it to work on my other spreadsheet. I think it has something to do with how the code is programmed with the button.... it has a problem at this part

.Shapes("Button 1").Visible = msoFalse
.Shapes("Button 2").Visible = msoTrue"

Any suggestions on how to set up my own version of your button on my other spreadsheet, or another way to get the code to work, would be greatly appreciated!

Thanks,
Robbie