Excel Automation

Hi Tim,

I’m trying to automate excel data.
I have 4 columns like A,B,C,D
A column has ID’s
B Names
C Numbers
D mail ID’s

I need to add column C data based Column A ID’s’(In column A,same ID will come more than once,we need to add Column C data
Column A Column C
101 10
102 20
103 30
101 40

When we add Column A ID 101 then Column C value will be 50

Please help us

Hi Tim ,
Could you please give me detailed solution.


Hi Tim,

Can you please elaborate how you set up Template table.

Did you do it in excel file or in Studio.