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. |
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. |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com