How to auto increment cell value after each printing results on each cell?

New Contributor

I have attached two pictures on the link below to describe it more simply.

https://imgur.com/a/ok50AIU

We need to find the optimum monthly Cost(cost effective) by changing order quantity and Re-Order points for a warehouse.

So I created the table on the right hand side and I want write an Excel or VBA function so that

  • every cell of the table will look at the order quantity value and Re-order point value from the graph, simulate the monthly cost and then print the coresponding monthly cost in each cell of that table.

any help would be appreciated.

Running scenario manager for each case is not practical since I have to set parameters for each case by hand.

0 Replies