Macro that’s autosums multiple cells and when totals zero inserts new line.

[Rmcholt]

Hi there

Need some urgent assistance if possible..

I have a spread that has multiple positive and negative numbers, i need to establish a macro that works down a column adding the two data types together and once total nets zero (ie the balance is zero )it inserts a new line and proceeds on to the next cell.

Column E

Ie. -10,000
10,000
-20,000
5,000
5,000
10,000
-40,000
40,000

Trying to establish as per below
Ie. -10,000
10,000

-20,000
5,000
5,000
10,000

-40,000
40,000

I hope this makes sense, and any help would be gratefully appreciated.

[Sintek]

Hi Rmcholt

Welcome to the Forum...Try this...Assuming Col A

Please Login or Register  to view this content.

[Rmcholt]

Sintek

you my friend, are blessed in this generation.

I am so thankful and grateful for this...thank you

[Rmcholt]

Sintek

are you also able to advise how i can set certain keys on my keyboard to colors ? ie when scrolling down any negative numbers to red and any positive to blue via the f keys ?

[Sintek]

Not quite sure but why not have the cells colours change automatically as the values are entered...
This in the specific Sheets module...

Please Login or Register  to view this content.