Excel automation - Pivot option

excel

#1

I am working in excel automation process. Sharing the requirement

sources excel file is having Department, Employee wise salary as below mentioned.

DEPARTMENT EMP_CODE SALARY
ABC E1 1000
ABC E2 800
BCD E5 2500
BCD E6 1500

While the target file will contain Department wise total salary .

DEPARTMENT TOTAL_SALARY
ABC 1800
BCD 4000

Please assist me . Thanks in advance .

Regards,
Avick


#2

record a macro , then execute the same through Execute macro activity