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?

On Dec 7, 4:39 am, tera <t...@discussions.microsoft.com> wrote:
> 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

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

"tera" wrote:

> 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?
>