Subtract with positive values

[abdul7019]

Hello, i rather new vba and i have found great a difficulty to find a solution for this problem.
I have a flat xls table with 100000+ rows and 100+ columns with blank cells, 0 value cells, >0 value cells and <0 cells . What i want to do is a vba code to run through every line and when it finds a <0 value cell to go back and start subtracting this value from the previous cells until it comes to =0 OR >0 (subtract only from the positive ones). Then continue from were it stopped (the negative value) until the end of the line. Then it has to loop for every line until the end. Blank and 0 cells are considered as 0 value.Please see below an example of a test dataset and the desired results. The "tricky" part is in Line 3 where the subtraction leads to negative result since there are no more values to subtract and in this case sets the cell value to 0.


Thank you in advance
Abdul Raheem

L1	100	50		0	-10	100			-50
L2	0		200	-100	-50	40	-10		50
L3		300		-400		100	50		30
L4	100	100	100	100		-450	100		-50
L1_Result	100	40		0	0	50			0
L2_Result	0		50	0	0	30	0		50
L3_Result		0		0		100	50		30
L4_Result	50	0	0	0		0	50

 

[Peter_SSs]

Welcome to the MrExcel board!

I have reproduced your sample data and expected results below. I do not understand the green value.
Since the first negative number in that row is -450, why doesn't that reduce all 4 100 values in A4:D4 to zero just like the -400 in row 3 reduced the 300 value to zero?

abdul7019.xlsm
	A	B	C	D	E	F	G	H	I
1	100	50		0	-10	100			-50
2	0		200	-100	-50	40	-10		50
3		300		-400		100	50		30
4	100	100	100	100		-450	100		-50
5
6	100	40		0	0	50			0
7	0		50	0	0	30	0		50
8		0		0		100	50		30
9	50	0	0	0		0	50
Sheet1

 

[abdul7019]

Thanks for responding

The macro should go and search for negative value the we have check if any positive value in that row we have to swap with that for each rows we can take the previous value or we can take forward value until it become zero

 

[Peter_SSs]

I'm afraid that did not explain why the green cell is 50.

As I understand it, for row 4 we start at I4 = -50
Moving left we come to 100 in G4 so we reduce G4 by 50 to give 50 and we change I4 to zero because we have used up the -50.
Moving left again we come to -450 in F4.
Moving left we come to 100 in D4 so it goes down to 0 and F4 would change to -350.
Moving left we come to 100 in C4 so it goes down to 0 and F4 would change to -250.
Moving left we come to 100 in B4 so it goes down to 0 and F4 would change to -150.
Moving left we come to 100 in A4 so it goes down to 0 and F4 would change to -50.

Where did I go wrong with that logic?
Why is A4 50 not 0?
And also, why is F4 now 0 and not still -50?

 

[Peter_SSs]

Hmm, it seems your original question in post #1 above is an exact copy of this one.
That thread was answered successfully in post #4 so I am closing this thread.
If your question is actually different - as appears may be the case from post #7 in that other thread - then please start a new question with your own sample data and your own requirements detailed in it.