Hide Rows Based on Cell Value

I'm looking for a macros that will allow the user to type in the number of subscribers (1 - 20) and then based on that number, have rows hide accordingly.

For example: C1 = 2, then rows 49-461 hide. C1 = 5, then rows 118-461 hide.


Any help would be greatly appreciated! I've been trying to work on this all morning and I just can't seem to get it right.

Macro.xlsm

I just recently did something similar, I got it working with your sheet as well, you can check the code out and modify it to your needs.

Macro.xlsm

jwats -
Nothing changes when I type a number into cell C1.

Check again, enter a 1 or 2 in C1, and look down at the rows in the 30-45 range, they will be hidden and unhide. Open up VBA and you can see my code and see what its changing, you just need to add the rest of your possible customer combinations and rows you want to actually hide. It will make sense when you look at the code

I double checked and I see your code, but when I enter any number into cell C1, nothing happens.

I double double checked - now I see it. Thanks so much! I'll adjust it accordingly.

Originally Posted by GoGoeGo

I double double checked - now I see it. Thanks so much! I'll adjust it accordingly.

No problem, its really simple way of doing it, just make sure that the first line

Please Login or Register  to view this content.

you adjust to encompass the very first row and very last row you change in your Cases. So in my example I'm only touching rows between 36:45, doesn't matter the combination of them, but that I state my smallest and largest row number I plan on touching.