Quote Originally Posted by Paul_Hossler View Post
"but it's REALLY not clear what you want to do if numbers are entered into each of the Cent/KG columns cells, or is it just the first or what?
I apologise if my explanation wasn't that clear. But you were correct in you "guess workbook".

Enter figures in $-column than make a calculation in Cent/Kg with the amount from Cell P19 (in my example wb). And then, if we should enter a number in Cent/KG we should do the opposite, and then calculate back to the $-column.

Because we have different targets in the company. Some requires e.g. a target of 6 Cent/KG, and then to do the forecast/budget we calculated back using the expected production amounts.

I hope this clarified it up.


And thank you for the code! It works how I would like it two.. I might tweak it a bit later to better suit the final workbook.

Best regards