?
Solved

VBA filter of large dataset.

Posted on 2015-01-29
7
Medium Priority
?
153 Views
Last Modified: 2015-01-30
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
0
Comment
Question by:DougDodge
  • 4
  • 3
7 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 40579404
Didn't we already worked on something similar to this ? It had current and past week I see here it has upcoming week is this the only difference just a first glance.
gowflow
0
 

Author Comment

by:DougDodge
ID: 40579470
Basically that was the only difference......
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40579506
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
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 40579517
Here it is.

I recall had commented out the selection change event as was annoying to see the screen blinking all the time. You have commented out the exit sub is there a reason for that ?

gowflow
SITE-PROGRESS-V02.xlsm
0
 

Author Comment

by:DougDodge
ID: 40579664
Not that I can remember....
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40580058
Anyway try the file I did not change this selection change event but got you what you wanted in this question
gowflow
0
 

Author Closing Comment

by:DougDodge
ID: 40580127
Works well...... Thank you once again.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
Gain an elementary understanding of Blockchain technology.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Integration Management Part 2

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question