DougDodge
asked on
VBA filter of large dataset.
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.
SITE-PROGRESS.xlsm
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.
SITE-PROGRESS.xlsm
ASKER
Basically that was the only difference......
Nope that was not !!! :)
You also had 3 rows per block now you have 4 times 2 with a blank separator !!! :)
Will revert shortly.
gowflow
You also had 3 rows per block now you have 4 times 2 with a blank separator !!! :)
Will revert shortly.
gowflow
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Not that I can remember....
Anyway try the file I did not change this selection change event but got you what you wanted in this question
gowflow
gowflow
ASKER
Works well...... Thank you once again.
gowflow