Hi there,
I would be extremely grateful if someone could help with the below please as I'm fresh out of ideas how to solve this!
Please see the attached.... I want to add a number between 1 and 300 in cell B2. This will then automatically generate the corresponding number of rows, starting at row 5 (rows 1 to 4 inclusive are to be always shown), going down to row 304, but always retaining the "Total Value" row on row 305 (irrespective of how many rows are above).
So for example, if I input "10" in cell B2, I would be able to see down to row 14, rows 15 to 304 would be hidden, and "Total Value" on row 305 would be shown. If I was to input "300" in cell B2, all rows would be shown. I hope that makes sense.
Can anyone help please?
I would be extremely grateful if someone could help with the below please as I'm fresh out of ideas how to solve this!
Please see the attached.... I want to add a number between 1 and 300 in cell B2. This will then automatically generate the corresponding number of rows, starting at row 5 (rows 1 to 4 inclusive are to be always shown), going down to row 304, but always retaining the "Total Value" row on row 305 (irrespective of how many rows are above).
So for example, if I input "10" in cell B2, I would be able to see down to row 14, rows 15 to 304 would be hidden, and "Total Value" on row 305 would be shown. If I was to input "300" in cell B2, all rows would be shown. I hope that makes sense.
Can anyone help please?