Referencing multiple dic.items in dictionary to clean up my code

I am currently using two dictionaries in one code, which works, but was wandering whether the code could be cleaned up so as to execute the same series of events using only one dictionary. I prefer to keep codes to a minimum if I can.

Essentially, the code checks one sheet for a product code. It then 'copies' the product code and data from two specific columns in the same row. If there are multiple of the same product code it will accumulate the data in the other two columns the 'end product' is just one row with the product code and accumulated totals adjacent.

Here is the code....what I am trying to do would be combine dic and dic2, but I cannot work out how...

Please Login or Register  to view this content.

Hi Strud
can you upload an example workbook

Sure...here you go..

I have omitted irrelevant data so ignore blank columns

Perhaps this:-

Please Login or Register  to view this content.

Regards Mick

Brilliant Mick that's perfect!!

I can see how you've referenced both items for one key:

Please Login or Register  to view this content.

So I'm with you.

Thanks for your help...was curiosity really but I think it's good practice to try to keep codes as clean as possible.

Thanks again

Your welcome
Regrds Mick