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?