ExcelBanter - hide rows based on value in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - hide rows based on value in cell (https://www.excelbanter.com/excel-discussion-misc-queries/71787-hide-rows-based-value-cell.html)

dummster

hide rows based on value in cell

How do I hide rows based on a specific value in a cell? Let's say if a user
enters the value "lucy in the sky with diamonds" in cell M48, then rows 44-50
should be displayed, if not, then hidden.

All times are GMT +1. The time now is 04:26 AM.