TRICKY: different data sets within the same page
Ranges A:D have fixed values. Ranges E:M have a mix of user input variables
and formulas.
I would like to create a toggle switch that allows a user to switch between
two sets of variables. It's essesntially like have two copies of Sheet 1.
The first copy would contain one set of data in the cells from E:M and the
second copy would contain a separate set of data. Both copies would contain
the same data in the cell from A:D.
The reason I would like to combine these into one page is because a user may
add or delete a row, or may create a different set of fixed values for
columns A:D...if this is done on only one page and not the other, the
comparisons become skewed. If it is combined into one page, Columns A:D
remain constant.
Matt
|