VBA code to change the Sheet 1 data as per Sheet 2

[motherindia]

Hello Sir,

I have 2 sheets. Sheet 1 contains 5 columns and Cust No is unique id. I need to combine the amount based on Cust No and also get the latest value for Type /1002 against SAP Period .

I need to automate to do this in VBA.

Input on Sheet 1
Cust No	Name	SAP Period	Type	Amt
1	A	201005	/1001	-30,637.00
2	B	200804	/1001	-1,974.00
2	B	200805	/1001	1,000.00
3	C	200810	/1001	-8,606.00
4	D	200802	/1001	-2,074.00
4	D	200803	/1002	-10,721.00
4	D	200805	/1002	-2,531.00
Output on Sheet 2
Cust No		Total (/1001+/1002)	//1002
1		-30,637.00	0
2		-974.00	1,000.00
3		-8,606.00	0
4		-15,236.00	-2,531.00

<tbody>
</tbody>

Regards,
motherindia

 

[motherindia]

Hello Sir,

Is it possible.

Regards.,
Motherindia

 

[motherindia]

Hello Sir

Any thoughts on the above. It would be great if something can be done.

Regards
Motherindia

 

[motherindia]

Hello Sir,

Hope my question may not be clear. Hence i will close this thread.

Regards,
motherindia.