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.
<tbody>
Input on Sheet 1
Cust No
Name
SAP Period...