Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Dynamic Data Range | Excel Worksheet Functions | |||
How to sum data that is only within a specific number range? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |