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).
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
Bookmarks