Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-20-2018, 10:11 AM
ChrisOK ChrisOK is offline Sum is Appearing in Wrong Column Windows 7 64bit Sum is Appearing in Wrong Column Office 2016
Advanced Beginner
Sum is Appearing in Wrong Column
 
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, 6 views)

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

Tags
paste; wrong column

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to delete duplicate of a column B based on column A and keep ColumnB if unique value to columnA enigmaprince OneNote 0 08-23-2017 01:30 PM
Sum is Appearing in Wrong Column Embedded Excel in Powerpoint - custom animation, display column by column andytheanimal PowerPoint 2 01-20-2015 06:30 AM
How can I temporarily break a 3 column format in order to type a single column paragraph William P Word 1 01-04-2015 06:40 PM
Want a quotient using a constant to show up in column c each time a number is added to column b fibbermcghee Excel 2 12-09-2014 05:48 PM
column break what am I doing wrong? oaty Word 0 08-12-2010 10:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft