Hi -

I'm looking for a macro that will hide specified range of rows depending on the text found in a cell.

Specifically, in the attached workbook on the "Dashboard Tab", when the formula in cell D3 returns "Year 5", I want the macro to hide rows 5:143. If the formula in cell D3 returns "Year 1", I want it to hide rows 39:179.

Any help?

Thanks!Deliverables Tracker_Excel Forum_6-23-2014.xlsm