Dear Sir,
I have 2 sheets . Sheet1 contains 5 columns of data as below;
<tbody>
Unique No
S Date
E Date
Amt
Type
1
01-Apr-17
30-Jun-17
100
A
1
01-Jul-17
31-Mar-18
150
B
2
01-Apr-17
30-Apr-17
100
A
2
01-May-17
31-May-17
200
B
2
01-Jun-17
30-Jun-17
300
A
2
01-Jul-17
31-Jul-17
400
B...