I have a large workbook with basically one worksheet. The detail data is in Columns "AN" thru "ON"
Daily the reporting needs to filter the data to Previous week, Current Week, Upcoming Week by use of a single cell as the Data Date.
The reporting section is in Columns "J" thru "AD"
Changing Cell "C2" should change the dates in "J19 thru AD19" so that if "C2" is 16-Jan-15, then 16-Jan-15 would be in the Current Week section in Cell "W19" as the end of the Current week.
The corresponding data in Rows "20" thru"28" matching the dates in Row 19 should be copied from the detail section starting in Column "AN" The values can just be Paste Value in Columns "J" thru "AD" from the detail section.
This same process needs to be repeated in all sections from Row 19 thru to 460 in blocks of 10 rows.
Since the data rows may grow or shrink over time, dynamic named ranges for columns would work best.
The columns are static, and will not change.
Help here would be so much appreciated.