Satheesh9012
New Member
- Joined
- Mar 19, 2021
- Messages
- 41
- Office Version
- 365
- Platform
- Windows
Hi
I am trying to hide and unhide rows in a sheet(b) based on the values entered in sheet(a), the values range from 1 to 6, so if 1 is entered in sheet(a) sheet(b) should hide rows from 32:125, if 2 is entered rows 51 51:125 should be hidden, if no value then rows 32:125 should be hidden.
Please help
I am trying to hide and unhide rows in a sheet(b) based on the values entered in sheet(a), the values range from 1 to 6, so if 1 is entered in sheet(a) sheet(b) should hide rows from 32:125, if 2 is entered rows 51 51:125 should be hidden, if no value then rows 32:125 should be hidden.
Please help