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?
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?