I'm trying to adjust a reporting file that currently looks at raw data for a one week period and generates reports through pivot tables. Each week's source data has to be on its own sheet, so traditionally, a new file is created each week. Other parts of the file generate data on a two week period, so I'm trying to adjust the file so that everything works across two weeks for consistency - if pivot tables would let me use a formula for this it would be easy, but I'm far from fluent enough in vb to code a solution.
Date selection will be a drop-down in Reports!E4. PivotTable2 and PivotTable4 need to be able to look at this date, and set the source as Data!$A:$M for the first 7 selections, or Data Week 2!$A$M for selections 8-14.
Any suggestions would be greatly appreciated.
Date selection will be a drop-down in Reports!E4. PivotTable2 and PivotTable4 need to be able to look at this date, and set the source as Data!$A:$M for the first 7 selections, or Data Week 2!$A$M for selections 8-14.
Any suggestions would be greatly appreciated.
