Hello,

I have two columns of data, column A has purchases and column B has sales. I'm trying to create a macro that will continually sum the values across columns A and B until the sum becomes 0, then, the remainder of the sales are recorded onto column C. And when 0 has been reached, all the other sales are moved to column C until there are purchases to count again. So it will look like below:

Original data
A B C
1 2760
2 1980
3 3220
4 -2450
5 -5550
6 -4670
7 -9330
8 3450
9 9200
10 2420
11 -47454

End result
A B C
1 2760
2 1980
3 3220
4 -2450
5 -5510 -40
6 -4670
7 -9330
8 3450
9 9200
10 2420
11 -15070 -32384

I've searched on this forum and other forums as well and this FIFO code kind of works, except I cannot get the sumIn to take the sum of A1:A3 before adding B4.

I have tried to code in a range, but excel won't accept it, and I assume it is because this is an array. I am not familiar with arrays so I am unsure how to fix the code. I believe this is the line that needs to be changed:

Please Login or Register  to view this content.
Any pointers would be greatly appreciated!