I have the following:
What I need is the formula sum(E1:E5) not just the absolue value the above macro gives me. Then I can see if I have errors. My ending units should now become my beginning units and the movements go to -0-. I need it for all columns, but if I get the logic I can apply to the other columns.