Hello,
I am making weekly summary in excel with downloading data from external source to table in excel. Then using PivotTable I filter data into smaller tables. Each week have his own "big" data table and couple small PivotTables. Each time I create new sheet with all the data for current week. And here I got the problem, each time I do this, I have to update datasource for each PivotTable to current's week "big" data table. Any way to make this non-static, dynamic per sheet, or force block PivotTable to take data from it's sheet?
Thanks for help!
I am making weekly summary in excel with downloading data from external source to table in excel. Then using PivotTable I filter data into smaller tables. Each week have his own "big" data table and couple small PivotTables. Each time I create new sheet with all the data for current week. And here I got the problem, each time I do this, I have to update datasource for each PivotTable to current's week "big" data table. Any way to make this non-static, dynamic per sheet, or force block PivotTable to take data from it's sheet?
Thanks for help!