Sort data per row no

    Hi

     

    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?