Get the pivot information without generiting pivot table - using function

  • Thread starter Thread starter J Chokshi
  • Start date Start date
J

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