Sort data per row no



    I have data per date (see example attached for 1 date). Work sheet with both incoming and outgoing.

    Each work-sheet in the file are sorted in order of booked transaction.


    I want to calculate the netted amount per transaction in row order (Incoming = credit, outgoing = debit).

    By sorting the data per row number I could get a curve of aggregated net-amount on the account (per transaction).


    How should I do?