Stopping spreadsheet at a certain number

[jrsnell]

I've been developing a worksheet that I use with clients to do some retirement planning. In one area, we ask how many years of retirement they anticipate and the typical response is to retire at 65 and enjoy 30 years of retirement.

I've put the spreadsheet together to aout 60 or so rows... so that if a client is 65, it will project out to 125 years of age. After the 30 years of retirement, the last 30 years (from 95 to 125) are just ignored... nobody wants to project retirement to 125!

Bottom line is that I'd like to default everything to stop at 95 and drop the choice of how many years of retirement. So, is there a way to basically just "end" the spreadsheet once column #2 (age) exceeds 95? I have been thinking to conditionally format to blank out everything after 95 and this might work, but IMO it's unelegant. Any other suggestions?

[day92]

Please provide an example worksheet of what you are talking about.

[jrsnell]

Hi... ok... If you look at the worksheet entitled "Worksheet", you'll see that at 95 all of this sample client's info goes irrelevant... which is ok because I would like the Age 95 row to be the last row anyway. The question is, how do I get rid of everything after age 95, conditionally... because every client is a different age?

[jrsnell]

Worded differently, if a client is 45 years old, I would like the spreadsheet to have 50 rows (95-45)... If a client is 58, I would like the spreadsheet to have 37 rows (95-58)... etc. etc...