Hello:
Please refer to attached file.
I have 2 sheets called Sales and Weekday.
As you can see Sales for Daily are shown in column L of Sheet "Sales".
I need a VB Code to summarize by Weeknum and day of the week as shown in "Weekday" Sheet.
Would need the Week Start Date and Weekend Date in column B and C.
I have manually completed for week 1
FY: My week start from Fri and ends on Thu.
Let me know if you have any questions.
Thanks.
Riz
Why not just go with formula.
In E3 enter =SUMIFS(Sales!$L$3:$L$37,Sales!$A$3:$A$37,">="&B3,Sales!$A$3:$A$37,"<="&C3) and drag it down
In F3 enter =SUMIFS(Sales!$L$3:$L$37,Sales!$A$3:$A$37,">="&$B3,Sales!$A$3:$A$37,"<="&$C3,Sales!$B$3:$B$37,F$2) drag it down and across
FWIW:
Please Login or Register to view this content.
Hi John:
For some reason it seems not work.
Please refer to attached file.
Let me know if you have any questions.
Thanks.
Riz
It works for me? Activate Sales and run it.
Hi JieJenn:
Looks like your solution will work great.
i still need 1 more favor.
I would i make column L variable so that i can choose which column i want to add.
This way i can do multiple data study by choosing the column and see the data.
Please Please let me know if you have any questions.
Thanks.
Riz
Just change the cell range reference. You have to do that also if you are going with VBA route.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks