Automatic hiding of rows based on variables

[Bob]

Can any one explain how I could set up a worksheet that
only shows certain rows based on an input variable? For
ex. the user inputs an age 35 - 70 & based on that input
another sheet would show calculations (i.e. retirement)
only up to that age.
Thanks

 

[Frank Kabel]

Hi
not really sure if you want to hide rows or if you want a conditional
calculation. could you give a specific example?

 

[Bob]

For example, one sheet has retirement pension calcs for
with each row containing pension payments per year up to
the age selected on another worksheet. If you
select '45' & then when to the worksheet with the
payments the information displayed would end at '45' and
all rows beyond that would be hidden.
This help?