Building a pivot table that changes based on defined range of raw data

macattack1

New Member
Joined
May 12, 2022
Messages
7
Office Version
  1. 365
Platform
  1. MacOS
Hi there again everyone. I hope everyone is having a nice Friday evening. I am running into an issue on excel with building pivot tables given a specified range for two date ranges, two numeric ranges, and five metrics. I built a filter function to filter the raw data given these specific constraints and built pivot tables off of that data. The problem I am running into is that when the ranged data changes, the pivot tables do not change accordingly. When I build a table for the ranged data, the Filter function will not run. My question is, does anyone know if it is possible to have the pivot table change whenever the ranged data changes? If so, how am I able to do that without building a table for the ranged data? Thanks for your help and consideration and have a great rest of your Friday and weekend.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,176,276
Messages
5,902,295
Members
434,959
Latest member
etb1025

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top