In the attached spread sheet screen dump, 'GSI' and 'mi' are input values, the green sell filled with '0.0161' (referred here as the 'output') is the output cell.
The calculation was performed through a range of complicated calculation from the data table at the top.
In the green tables at the bottom, the vacant areas are to be filled with the output values corresponding to a range of GSI & mi data pairs.
I can only think of copy GSI and mi values one by one into their input cells (highlighted in yellow) and then paste the output value back to the green table. As can be expected, it will take a long time to do that, as i have to do exactly the same thing again for another output parameters.
I have tried simple macro recording and play, but it didn't work well under this circumstances.
Can anyone help with this?
Bookmarks