Conditional hiding of rows in Excel

nsumner

New Member
Joined
Feb 2, 2005
Messages
3
What I want to do is in theory very simple, but in practice I have no clue how. I suspect it can be done with some simple VBA scripting but I don't even know where to begin in creating a VBA script or where to put it into Excel.

I want to either display or hide complete rows (not simply make them white that is easy enough), depening on some other data (actually coming from another worksheet (but of course if needed it can be but on the same worksheet in some hidden area (simple refrence)).

Basically I have somebody in another worksheet decide how many periods they need to calculate for (I currenty allow 1-15 but if I can get this working would probably allow 1-25 but that doesn't matter). All the calculations are done on that page and another sheet links to the answers.

Therefore on the final output sheet I don't want empty space in the middle of something because there was no data to enter. I want to display all data that is needed but blank rows.

Can somebody help me out?
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,123,336
Messages
5,601,023
Members
414,421
Latest member
tonybear1994

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top