eagerexcel
New Member
- Joined
- Apr 17, 2012
- Messages
- 3
I have created a workbook that I need a macro for
In sheet one I have inserted a "push button" that I'm assigning a macro to in sheet 3
All calculations and fields are already completed at this point. What I need is the system to jump to sheet 3 and hide all the rows that have a "No" value in column S
To explain more:
The columns A - R has information in it.
The deciding cell is the cell in column S. If the cell has a "No" in it I want the entire row to be hidden.
I have tried to figure it out by playing but have come up short
Please help
In sheet one I have inserted a "push button" that I'm assigning a macro to in sheet 3
All calculations and fields are already completed at this point. What I need is the system to jump to sheet 3 and hide all the rows that have a "No" value in column S
To explain more:
The columns A - R has information in it.
The deciding cell is the cell in column S. If the cell has a "No" in it I want the entire row to be hidden.
I have tried to figure it out by playing but have come up short
Please help