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@it-tallaght.ie - 07 Dec 2007 10:11 GMT
> Hi ,
> I have got a requirement as follows
[quoted text clipped - 18 lines]
> -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 - 13 Dec 2007 17:39 GMT
Hi,
This does not server my purpose. Is it possible by developing some Macro?
and in that case may I expect any help?
> Hi ,
> I have got a requirement as follows
[quoted text clipped - 18 lines]
> -existed in the target template)
> Can anybody help me plz?