Hello again,
I have a cell, C2, that will have a tab name pasted into it each time a new page is created. This name will be equivalent to a filter in PivotTable1 on that page.
Is there a way that I can have it that when the name is pasted, the filter "Time" can be linked to that cell and update in the pivot table?
I searched for a while online and was unsuccessful to find an answer. Any help is much appreciated!
Thanks!!
Bookmarks