I have a spreadsheet that figures out multiple different payment options for
different terms depending on the intrest rate, contract amount etc. I would
like to simplify this and be able to choose the intrest rate and have the
spreadsheed just display my payment options for that particular intrest rate.
at 8 different term rates . I cant seem to fiqure out how to display a range
of data on a different worksheet.

thanks.