Insert rows in between a range from another range based on dates

Hello,
I am new to this forum and trying to seek some help.
I have an excel which has following data divided into 2 ranges Credit and Debit

Worksheet 1

DATE CREDIT DATE DEBIT
25-11-16 300 29-11-16 -90
09-12-16 300 13-12-16 -90
23-12-16 125 27-12-16 -90
06-01-17 125
07-01-17 300

In worksheet 2 I want this two ranges to be merged and output as

Date Cumulative Points
25-11-16 300
29-11-16 210 -- Derived as (300-90)
09-12-16 510
13-12-16 420
23-12-16 545
27-12-16 455
06-01-17 580
07-01-17 880

I am new to VBA and have tried to understand some codes I found, like -

Sub test()
Dim c As Range
  For Each c In Range("A:A")
    If c.Value Like "0" Then
      Rows(c.Row).Insert shift:=xlDown
    End If
  Next c
End Sub

But here it inserts a blank row whereas I am trying to insert from another range. Can anyone please help me with some idea and sample code.

thanks,
PS