Sheila8659
New Member
- Joined
- Mar 1, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
I am working with a price list and would like to select pivot table fields (column headers) based on the price level (PL) selected which is also a column headers. The price level is indicated by Z0 and Z1. This particular column header can be used or not as part of the solution because there is also a helper table located on another sheet being used in PQ to generate calculated columns for other sheets. The helper table can be used and would most likely be a better option if possible. A compiled price list is on still another separate sheet and is the source data for approximately 100 individual pivot tables (one for each group). If code is used, it would need to work on the entire workbook. I have found ways to select rows, but not the column by header name (fields). However, since not everyone on my sales team are excel savvy, I would rather use PQ or a slicer if possible so that the pivot table are easily refreshed.
My objective is to only have only one pivot table for each group that can be toggled by Z0 or Z1 from helper sheet and all pivot tables in the workbook will be refreshed when refresh all is clicked. I have a lot of VBA code and PQ connections in this workbook already, along with images on each of the pivot table sheets. I would like to find a solution that will not interfere with the current progress of the workbook and will be easy to use across all skill levels.
*Note: Not all column headers are listed in the group example due to sensitive information.
Example Description:
Z0 Example: Select Z0 and the fields in the Z0 example are selected.
Z1 Example: Select Z1 and the fields in the Z1 example are selected.
235 Example: A broader view of the end result for each group.
My objective is to only have only one pivot table for each group that can be toggled by Z0 or Z1 from helper sheet and all pivot tables in the workbook will be refreshed when refresh all is clicked. I have a lot of VBA code and PQ connections in this workbook already, along with images on each of the pivot table sheets. I would like to find a solution that will not interfere with the current progress of the workbook and will be easy to use across all skill levels.
*Note: Not all column headers are listed in the group example due to sensitive information.
Example Description:
Z0 Example: Select Z0 and the fields in the Z0 example are selected.
Z1 Example: Select Z1 and the fields in the Z1 example are selected.
235 Example: A broader view of the end result for each group.
