Hi,
Just so you know my level, I am a dummy user of vba, who was able to accomplish couple simple codes and now want more .
I am interested in following question. Not even sure if this is something to involve VBA or maybe there is an excel function to handle this?
It is easier to describe what I mean on the attached example:
I have excel based calculations, based on various inputs a "result" cell value is being calculated (Cell B21).
For one of input cells (Cell B3) I have a table of possible values (F2:F13). I need to get result cell values for each of possible input cell values and collect them in the table next to inputs (G2:G13).
Is there a way to make this work without copying entire original table of calculations multiple types and changing input values manually?
Thank you
Bookmarks