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.

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" <(E-Mail Removed)> wrote in message
news5936065-5130-4360-9872-(E-Mail Removed)...
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.