Sounds like you could use dependant drop-down lists.

Check out this site of Debra Dalgleish:

http://www.contextures.com/xlDataVal02.html

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"colligan25" wrote in message
...
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.