+ Reply to Thread
Results 1 to 5 of 5

Scripting Dictionary - CompareMode only partially working...

  1. #1
    Registered User
    Join Date
    02-01-2013
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    44

    Scripting Dictionary - CompareMode only partially working...

    Hello again!!

    I am having a problem with the use of the scripting dictionary in a macro.

    This worked great before, but I had to change my dataset that this whole workbook was pulling from because it was incorrect.

    I made the change, I got the code to combine all the like products and return the total for each product on the "results' tab in Column "U".

    My problem is, that when it is supposed to copy the totals (column "U") and paste them beside the matching product types on another sheet (sheet5), it is only taking 3 of them and not all of them.

    here is the code that I am using, which works for everything except transferring ALL the totals to the correct spots on the new sheet (sheet5).

    Please Login or Register  to view this content.
    it is probably something simple that I am missing... but it just seems odd that it only takes 3 of the totals and pastes them.

    I hope that I am clear enough with what it is supposed to do, if not ask questions, and I will attach a sample file to this as well...

    Thank you!!

    example5.xlsm

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Scripting Dictionary - CompareMode only partially working...

    Yes, there are only 3 matches if you compare column E of result sheet with column B of sheet5.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-01-2013
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Scripting Dictionary - CompareMode only partially working...

    AB33...

    thanks... I actually didn't look that closely at that.

    and this is why I tell them that I hate changing the source data after a worksheet has been created, it causes issues like these.

    I look at these numbers all day long and didn't even catch the ending numbers..

    thank you!! that means that what I have is actually working, and I need to adjust the item descriptions..

    man... my Las Vegas vacation was too short!!!

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Scripting Dictionary - CompareMode only partially working...

    Yes, the code was working perfectly. I have slightly amended the last bit to catch any non string values.

  5. #5
    Registered User
    Join Date
    02-01-2013
    Location
    Washington
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Scripting Dictionary - CompareMode only partially working...

    perfect.. thank you!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1