Get the pivot information without generiting pivot table - using function

[J Chokshi]

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

 

[Shane Devenshire]

Hi,

Based on your Subject line - you can create a formula solution, but we can't
be much help without a lot more details, for example, what does you data
layout look like, what do you want the report area to look like?