Hi all.
So I have a calculation sheet with input and output in some cells. And I have list of inputs (and initially empty outputs).
I want to do iteration by changing input cells from the input list, then calculate sheet, then store output values to the output list.
I need to do this without macro because our office often have this situation (with different calculation sheet and input list), so not easy to make macro all the time.
I knew there was excel feature for this, but not sure what is the name, something like Scenario or Table (but not Table as of ListObject).
Can someone help me how to do this?
TIA
So I have a calculation sheet with input and output in some cells. And I have list of inputs (and initially empty outputs).
I want to do iteration by changing input cells from the input list, then calculate sheet, then store output values to the output list.
I need to do this without macro because our office often have this situation (with different calculation sheet and input list), so not easy to make macro all the time.
I knew there was excel feature for this, but not sure what is the name, something like Scenario or Table (but not Table as of ListObject).
Can someone help me how to do this?
TIA