ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Report Parameters to be named and saved like 'View' na (https://www.excelbanter.com/excel-discussion-misc-queries/39441-pivot-table-report-parameters-named-saved-like-view-na.html)

Shrikant

Pivot Table Report Parameters to be named and saved like 'View' na
 
I have generated different Pitot Table Reports from the Sales Invoice
Register. These reports give rgionwise, productwise, timewise info in
different combinations and appearance. Unfortunately, as I change the
parameter of the report, it replaces the existing report and generates the
new report. One solution is to have each report in separate worksheet. But
this will substantially increase the number of worksheets. What I would
prefer is to give a name to these parameters and save it. Whenever I want a
particular report, all I have to do is to select that name from the scroll
down list. This facility is similar to the 'View' facility.
I hope I am sufficiently clear.

--
Shrikant

Shrikant

If this is not possible, then I would like to post this matter in the
'Suggestions to MS' item.
--
Shrikant


"Shrikant" wrote:

I have generated different Pitot Table Reports from the Sales Invoice
Register. These reports give rgionwise, productwise, timewise info in
different combinations and appearance. Unfortunately, as I change the
parameter of the report, it replaces the existing report and generates the
new report. One solution is to have each report in separate worksheet. But
this will substantially increase the number of worksheets. What I would
prefer is to give a name to these parameters and save it. Whenever I want a
particular report, all I have to do is to select that name from the scroll
down list. This facility is similar to the 'View' facility.
I hope I am sufficiently clear.

--
Shrikant



All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com