Group Weekly Data with Totals for that Week VBA - Group by Date
Attached example of what I'm needing - the Before and After Tabs show what the data looks like and should look like..
Just need data grouped into weekly segments and a total for each week and was going to attach the vba macro run to a button to save time on this weekly effort.
NOTE: If the results could be generated onto a new sheet while leaving the "BEFORE" sheet as is, this would be ideal.
Thank you greatly!
Last edited by CHRISOK; 11-27-2017 at 03:02 AM.
Try
Please Login or Register to view this content.
Last edited by jindon; 11-27-2017 at 07:25 AM.
Thank you jindon! - This is the perfect solution! It works so well to generate a quick weekly overview of what's due by week! (which is what the boss is wanting to see) Thank you so much! Saved a lot of headaches! (I gave you stars in the Reputation area)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks