Automatically Calculate Desired Number

[tdm1103]

I have an excel sheet in which 24 consecutive columns(row 2, columns A-X) have a numerical values in the same row based on other information in the sheet. The value can go up or down depending what numbers are below it (sales or purchases). For example the value in each cell is 100 units, but I want it to be 180 units. I need to sell 80 more units to get to the desired number of 180 units.

Is there code that a Macro Button can be pressed by the user so that depending on value of the cells in row 2 a sale or purchase number will be created so that total units equals 180?

 

[swst]

Have you looked at the GOAL SEEK option under TOOLS

Steve

 

[Meedan]

You can also use Excel Solver. (Solver is an Excel add-in supplied with Excel)

It can solve problems by enabling a Target cell to achieve some goal.
This goal may be to mininimse, maximise, or achieve some target value.

It solves the problem by adjusting a number of input cells according to a set of criteria or constraints which are defined by the user.

 

[tdm1103]

Thanks for the feedback. I will try both options and see how it works out.