Hi
Thanks for your reply. But It wont work for number of columns.
However I have received answer from AFSSKier, I will try the same.
Hemant.

"trip_to_tokyo" wrote:

Hi Hemant, I have just put your example up on:-

www.pierrefondes.com

(top item on the home page)

- to show you what I have done / mean.

Maybe this helps you / or others to be able to answer your question?

If my comments have helped please hit Yes.

Thanks.



"Hemant" wrote:

Month Gross Consumble Custom Clearing Battery
Apr-05 3187 3187 0 0 0
Apr-05 44779 0 300 44479 0
May-05 18900 0 18900 0 0
May-05 13087 0 0 0 13087
Jun-05 9900 0 0 0 9900
Jun-05 29856 0 29856 0 0

If I Insert Pivot table & select Month as Row label & Select Gross,
Consumables, Custom etc as sum Values, the column heading shows "Sum of
Gross", "Sum of Consumables". Is there any facility to design the column
heading without the words"Sum of" & retain the original headings in the pivot
table. This will help me to copy the pivot table values.?