Get the pivot information without generiting pivot table - using function

Giganews Newsgroups
Subject: Get the pivot information without generiting pivot table - using function
Posted by:  J Chokshi (jackchoks…@hotmail.com)
Date: Wed, 18 Mar 2009

Hi All;

I am challenged with one report which need to be converted daily to
particular worksheet.

Daily I  have to generate pivot chart and then refer the chart columns to
the worksheet.

Is there any way I can run any function can filter and pivot my data and I
can get the required information from list?

Any help would be awesome.

Thank you, Jack

Replies