VBA to distribute data monthwise based on start and end date range

[motherindia]

Dear Sir,

I have 2 sheets . Sheet1 contains 5 columns of data as below;

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
2	01-Aug-17	31-Aug-17	500	B

<tbody>
</tbody><colgroup><col><col span="2"><col><col></colgroup>

I need to update the info Sheet 2 against the unique id as below;

Amt

Type

Unique No

Apr-17

May-17

Jun-17

Jul-17

Aug-17

Sep-17

Oct-17

Nov-17

Dec-17

Jan-18

Feb-18

Mar-18

Apr-17

May-17

Jun-17

Jul-17

Aug-17

Sep-17

Oct-17

Nov-17

Dec-17

Jan-18

Feb-18

Mar-18

1

100

100

100

150

150

150

150

150

150

150

150

150

A

A

A

B

B

B

B

B

B

B

B

B

2

100

200

300

400

500

A

B

A

B

B

<colgroup><col width="64" style="width: 48pt;" span="25">
<tbody>
























































































Kindly do the needful.

regards,
motherindia </tbody>

 

[motherindia]

Hello Sir,

Can anyone help to modify the code to speed up. It will help me in processing 2 lakh rows quickly.

Regards,
motherindia.