+ Reply to Thread
Results 1 to 2 of 2

display a range of data when triggered by a specific condition

  1. #1
    colligan25
    Guest

    display a range of data when triggered by a specific condition

    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.

  2. #2
    RagDyeR
    Guest

    Re: display a range of data when triggered by a specific condition

    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" <colligan25@discussions.microsoft.com> wrote in message
    news:D5936065-5130-4360-9872-972AAC94F766@microsoft.com...
    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.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1