Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Getting a Pivot Table to Update off of a Dynamic Range
The pivot table is created from and output of the query. So they are not directly linked in any way. And yes there are multiple months worth of data being fed into the table, but only want the month that is selected in my month toggle cell to appear in the PT.- tpfennin
- Post #6
- Forum: Microsoft: Office
-
Getting a Pivot Table to Update off of a Dynamic Range
It is just a month field. I have a list of the 12 months as a named range which is then added as data validation on a single cell. That cell is referenced by all the formulas in the output sheet so as it changes the formulas pull in new data from the query. The formulas in that sheet are...- tpfennin
- Post #3
- Forum: Microsoft: Office
-
Getting a Pivot Table to Update off of a Dynamic Range
I have construced a tool that updates automatically based off of a sql query and a dynamic named range of months. The month toggle updates the output page. Is there a way to tie that month toggle to a pivot table? Everytime I update the month the pivot table, I have on another sheet, gets...- tpfennin
- Thread
- Replies: 9
- Forum: Microsoft: Office
