Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Data and Looking Up Info.
I am trying to create a spreadsheet that will populate percentages when a
user selects which option they want from a validation list. To be more specific, I am trying to create an asset allocation spreadsheet. At the top of the page, the user has the option of selecting from Conservative, Moderate, Aggressive or Custom from a validation list. Let's say the user chooses Conservative, I would like the appopriate percentages for Large Cap, Mid Cap, Small Cap, International, etc. to be populated automatically according to a Conservative allocation. And the same goes for Moderate, Aggressive and Custom. Does this make sense? Is it possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Populating Data and Looking Up Info.
I was able to accomplish this, more or less, using a variety of macros and
buttons. Thanks anyways. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|