aWorkingPig
New Member
- Joined
- Jul 25, 2020
- Messages
- 4
- Office Version
- 2013
- Platform
- Windows
Hi all,
I have a spreadsheet with 52 identical sheets/tables, plus a formula based dashboard to monitor week to week changes.
I would like to set up some pivot tables to pull data from the corresponding table based on the week/ date selected in either a Data Validation list or ideally a Slicer.
I've been able to do this manually by selecting 'change data source' but am hoping someone can help with a possible VBA solution to change the pivot table source data based on a cell value or Slicer (i.e. by selecting the Week no. or Date)
I already have a list of the 52 weeks. "Week 1 and 30/03/2020, Week 2 and 06/04/2020...."
I have a spreadsheet with 52 identical sheets/tables, plus a formula based dashboard to monitor week to week changes.
I would like to set up some pivot tables to pull data from the corresponding table based on the week/ date selected in either a Data Validation list or ideally a Slicer.
I've been able to do this manually by selecting 'change data source' but am hoping someone can help with a possible VBA solution to change the pivot table source data based on a cell value or Slicer (i.e. by selecting the Week no. or Date)
I already have a list of the 52 weeks. "Week 1 and 30/03/2020, Week 2 and 06/04/2020...."