Hello,
I am new to this forum and i am having issues with adding the value of the next cell to the negative value of the previous cell.
Cell values are dynamic and not always in order. Is there an excel or vba command to get the value of positive numbers and
add it on the negative value to make it positive and rebalance?
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]123[/TD]
[TD]456[/TD]
[TD]789[/TD]
[TD]1011[/TD]
[TD]123[/TD]
[TD]description[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]200[/TD]
[TD]1888[/TD]
[TD]-2088[/TD]
[TD]-1000[/TD]
[TD]dynamic amount[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]from[/TD]
[TD]to[/TD]
[TD]amount[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]1011[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]1011[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]1011[/TD]
[TD]888[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]1213[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
if checked the total amount of negative values is equal to -3088
now I did rebalance it by adding the value of the positive amounts from left to right.
The total value of the positive amounts is also 3088. Now after rebalance there's no more negative values.
Do i have to write a function for this or a simple loop will do the trick?
I am new to this forum and i am having issues with adding the value of the next cell to the negative value of the previous cell.
Cell values are dynamic and not always in order. Is there an excel or vba command to get the value of positive numbers and
add it on the negative value to make it positive and rebalance?
[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]123[/TD]
[TD]456[/TD]
[TD]789[/TD]
[TD]1011[/TD]
[TD]123[/TD]
[TD]description[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]200[/TD]
[TD]1888[/TD]
[TD]-2088[/TD]
[TD]-1000[/TD]
[TD]dynamic amount[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]from[/TD]
[TD]to[/TD]
[TD]amount[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]1011[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]456[/TD]
[TD]1011[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]1011[/TD]
[TD]888[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]789[/TD]
[TD]1213[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
if checked the total amount of negative values is equal to -3088
now I did rebalance it by adding the value of the positive amounts from left to right.
The total value of the positive amounts is also 3088. Now after rebalance there's no more negative values.
Do i have to write a function for this or a simple loop will do the trick?