Aggregation on Column Value (groub by logic)

[tera]

Hi ,
I have got a requirement as follows
My input data is as
A/C Code Value
1 100
1 150
1 75
2 100
2 200


I have a defined format for output (in same worksheet of where the above
template is located) as
A/C Code Title o/p Value

A/C code should be displayed only once and o/p value should be aggregated
value on A/C code (A/C should be available in the ouput template)
the expected out put should be
A/C Code Title O/p Value
1 AAA 325
2 ABB 300 (A/C Code and Title would be pre
-existed in the target template)
Can anybody help me plz?

 

[paul.robinson]

Hi ,
I have got a requirement as follows
My input data is as
A/C Code Value
1 100
1 150
1 75
2 100
2 200

I have a defined format for output (in same worksheet of where the above
template is located) as
A/C Code Title o/p Value

A/C code should be displayed only once and o/p value should be aggregated
value on A/C code (A/C should be available in the ouput template)
the expected out put should be
A/C Code Title O/p Value
1 AAA 325
2 ABB 300 (A/C Code and Title would be pre
-existed in the target template)
Can anybody help me plz?

Hi
Have you tried using a Pivot Table?
Select your two columns with headers and do Data, Pivot Table and
Pivot Chart Report. Click Next. Click Next. Choose where you want the
table. In Layout drag A/C Code to the Row area and Value to the Data
area. Click Finish.

regards
Paul

 

[tera]

Hi,
This does not server my purpose. Is it possible by developing some Macro?
and in that case may I expect any help?