Find the Maximum Value in a range and updating cell

  • Hi,

    I am trying to use the Solver tool, but in order to do so I need to have the criteria being met before the Solver is run.
    In order to meet the criteria I need a macro to run to update the values in a column.

    Attached is the document I am working on.

    The criteria for the Solver are that the Total Fuel Consumed must be equal to the Expected Bunker Consumption.

    I therefore need to deduct from Column "O" the value in "I5", such that the value in Column "O" is always positive.

    Can someone help me come up with the macro to do this. My attempt is called UpdateMax found in the Macros section. I can't quite get it to work.

    Any help would be really appreciated

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!