I created a financial model with multiple linked worksheets in excel. In a
particular worksheet, I have 12 columns of data represented three areas of
four
column each, the areas a the base case, the new case, and the model
case. I
have two option buttons, one button for the base case and one button for the
new
case. I want to be able to allow the users of my model to be able to select
either the base case or the new case and when they choose that option that
data
will populate the columns in the model case section. The model case section
is
the data that i want to use in other worksheets in the financial model, but i
need to know which case (the base or the new) they choosing to use. I want
to be able to link the columns related to the base case to the base case
option button and the columns related to the new case to the new case option
button and depending upon the option selected have that option's columns
populate the model case columns.