Excess rows while running code

[Ravana]

Hi all,

I am using Solver (add-in) for optimisation of distance-cost.

I have added a button in the sheet ("FRONT PAGE") and when clicked, the Solver will run the program and output the various number of distance for each product (br, rr and wheat) in Sheets ("br", "rr" and "wheat").

In these sheets, in Col C, I get the total variations and in Col D says from where and COL E says to where.(Same for the three sheets br, rr and wheat).

In the Sheet ("Solver Values") D1, D2, D3, and D4 is the number of variations for each particular - br, rr and wheat.

The problem I am facing is, when D3 says 79 in Sheet ("Solver Values"), I am getting 84 variations "rr" sheet.

Even in Output Sheet, total shows excess (instead of 358 (d1+d2+d3+d4 of solver values sheet) it shows 363).

Please help.

I am sharing the link of the workbook as the file is nearly 20 MB.

[Ravana]

Bump...anyone?

Moderator comment: Please read the forum rules you agreed to when you joined the forum. Pay attention to the notes on bumping threads. Allow 24 hours before you bump a thread. All forum members here are volunteers. They are here to help when they have the time. They do not necessarily work to your needs or schedule. We are a worldwide forum with participants from all over this planet in various time zones. Give them a chance.

[Ravana]

Duly noted.!!