Two Totals Pasting to Wrong Column - The rest are pasting correctly

[CHRISOK]

Had to change the order of how the user would do things - and in the process something got jacked up that's causing the top 2 line items in a Weekly Subtotals Column to jump out into columns to the right that they don't belong within..
All the rest are pasting into the correct column..

Have run that last module --what seems like a hundred times, tweaking things to try to fix it - but no luck..
Test File attached showing the issue..
Thank you

[xladept]

It ran like this:

Please Login or Register  to view this content.

*Is it what you want?

[CHRISOK]

No, sadly, all of the weekly totals (sum) should be appearing in col H as shown in the sample attachment

When I ran the above - it has wiped out all totals (both in col H) and the 2 problematic totals that were appearing out in col I and J

[CHRISOK]

The above solution suggestion did not work -- hoping someone might see where the problem lies?

[CHRISOK]

cross posting today after waiting a couple days for insight
http://www.msofficeforums.com/word-v...tml#post124924

[xladept]

Yeah, what I've been trying hasn't yet cut it

[CHRISOK]

awe -- THANK YOU for taking a stab at it --- I've tried changing some things around a bit but with no luck -- =-(

[xladept]

I didn't clean it up but this now seems to work!

Please Login or Register  to view this content.

The problem was with using LastR columns count which was 9 for the false flag and just 7 for the rest of the rows - as you can see I changed that to 8

[CHRISOK]

Well, xladept - it's a bit closer - but something funky is still going on -
The 2 totals that were jumping out to the right are back in H (how'd you get them back over?), however, there's an additional total in col H in H9 that should not be,
The grand total that should be at the base of col H is sitting in I (not calculating b/c it's looking at I)
And not sure where the new column header "To Be Deleted" came from (maybe in your testing?) - but it shouldn't be there (that might be what you mean by cleanup)
(attaching the result file of the newest code you just provided - for an online look)

[xladept]

Still not cleaned up but "closer"

Please Login or Register  to view this content.

[CHRISOK]

xlsadept: looks like whatever you changed this time around fixed the issue!
Thanks so much! I'll be sure to click reputation stars for you

[xladept]

Wow - that took a while!

You're welcome and thanks for the rep!

The dates from the source sheet we're populating in H - so, we put the formulas in I and deleted H at the end

(along with other things)