[sanddrag]

Here's what I want to do in Excel. I want to have a bunch of data (like forces on an object sitting on a ramp) based on the input of something like an angle in degrees from 0-90 in 1 degree increments. I would like to have all 90 rows, one for each angle. But say I want to display the data for only 0-30 degrees. Is there some sort of function I can use where I'll have a cell for "up until what angle do you wish to display?" and then I won't see anything beyond whatever value is input in that cell?

Or maybe I shouldn't say controlling the visibility, but maybe controlling how many times the formula from the first cell is copied down. Or maybe when you input "up until what angle" it will create those cells on its own.

Sorry I didn't describe that well but hopefully you understand what I'm trying to do. I'm not sure if it is possible, but I thought I'd ask.

If you have a question about my description of what I want to do, please ask and I'll try to clarify.