There are plenty of ways to skin that cat. Just off the top of my head...
* You could have to separate sets of data and equations on the same sheet.
* You could have a drop down box to select which output which would code to modify the inputs/equations appropriately.
* You could separate the data entry from the display cells.
|