I work for an insurance agent. When we prepare quotes for clients, we show them an excel spreadsheet with the various benefits compared. I would like to create a worksheet that has all the various benefits for commonly proposed plans listed, and then a second worksheet with a dropdown list of those plans. Thus, when a plan is selected on the drop down, the cells below are populated automatically with the benefits of that plan. Is this possible? Can I name a series of cells, and then have the data imported once the name of that series is selected from a dropdown?
This conversation is currently closed to new comments.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel Dropdowns