How to make a loop writing a value in an excel cell and reading the value in another one?Can be with or w/o VB?

I have created a system on my microsoft excel for mac which calculates the production costs of many products. If I change the cell ';quantities';, it changes all parameters to find the production cost. I would like to plot a graph of quantities X production costs. I've never made anything in VBA. Is there any way of making this without VBA? How do I do itHow to make a loop writing a value in an excel cell and reading the value in another one?Can be with or w/o VB?
You cab create a data table to produce the outcome you need. These will work just the same on a MAC Excel 2004 or 2008. Lots of examples on the Internet.



If I have misunderstood the question consider also Goal seek, Solver and scenarios in Excel (source 2 below)