Excel already has the functionality to do this without using macros.
Scenarios allows you to compare different iterations of data based on
separate inputs. If that doesn't do what you want, then we can try and
create something

"Midas" wrote:

I have created a file with several calculations. When I enter a certain value
the file creates new values over several rows.
But when you change the value entered previously the file changes, off course.

Is it possible to create/program a macro that uses data from a list,
calculates the values en then places the outcomes in new rows/colums?

So its not necessary the reenter new values every time and register the
outcomes.

thanks!