Stock adjustment Data in excel

[webmax]

Hi

I have 3 following datas in the columns
1) Opening Balance
2) Product Sold
3) Closing Balance (Difference between Opening balance - Products Sold)

In the attached excel sheet some of the closing balance is showing as negative (Minus).

If the Closing balance is less than zero like (-1,-2,-3 etc) then the Product sold column to be changed like decrease 1 number (-1) till the closing balance come to zero.
For example in the first case the Product Name apple Opening balance is 100 and unit sold is 105. The closing balance is showing as -5
Now the units sold be changed to 100. Now i doing manually till the closing balance get zero.
This should do only if the closing balance is negative balance.
I need this in macro because i have many of products using loop based on the available data in the sheet.