View Single Post
 
Old 02-20-2018, 10:11 AM
ChrisOK ChrisOK is offline Windows 7 64bit Office 2016
Advanced Beginner
 
Join Date: Sep 2016
Posts: 54
ChrisOK is on a distinguished road
Question Sum is Appearing in Wrong Column

Wkly Totals tab: Col H should hold all the totals for each wkly segment of invoices but for some reason in Row2 and Row7 the totals are not being placed appropriately into Col H like all the others are -- and I'm not sure what needs corrected in the code to fix it?
Module2_GroupWeekly is the area where the problem lies..
I've marked the spot where it appears to occur using F8 but not sure how to fix?
*Attached is a test file

An explanation of how the file, it's Modules and tabs are supposed to work is provided on that Wkly Totals tab (if needed).

cross posted the other day but doesn't look like anyone knows how to fix it thus far..
https://www.excelforum.com/excel-pro...correctly.html
Attached Files
File Type: xlsm invoice-010318-NEW-021318-8.xlsm (118.8 KB, 8 views)

Last edited by ChrisOK; 02-20-2018 at 10:51 AM. Reason: NEEDS DELETED - ACCIDENTALLY POSTED UNDER WORD VBA
Reply With Quote