I have created three sheets of formulas for a project. I've determined that
I need to further analyze the affects of just two inputs on one result. I
would normally create another sheet with the one range of inputs along the
top and the other range of inputs along the side and then have each cell in
the table be a long string formula that would give me the answer and update
every time I change something on the other sheets. However, this time there
are a thousand calculations between the one input and the result I'm looking
to display. Is there a shortcut?