What i need in the end is this:
- from the book1 example i want the quantity in m the I multiply it with the price that i get from another index and i get a product. That would be the ammount that i have spent for a quantity from a certain suplier. And at the very end I need to see how much i have saved (or not) by choosing on suplier over a standard price set by the board.The thing is that i have a lot of products and a lot of supliers + 12 months that results in hundreds maybe thousands of cells being populated with array formulas and that slows the workbook alot.
Thats why I am trying to setup this macro to see if it can do it faster. The workbook with formulas is already working but its slow and it will only get slow with every extra product and suplier.