I've created 3 dictionaries and all my dictionary have in common the Key which is an ID Code.
dico1 (id, product name)
dico2 (id, amount for sells)
dico3 (id, amountI'dr buys)
- I'd like to paste the Product name of the first dico in column A
- The product name from this dico in Column B
- The amount for sells in column C
- And amount for buys in column D
Can you help me on this?
I imagine that I should set a variable like Id and for each Id (that appears on one of my sheet > DataSheet column B).
I need to loop check the Id and then get the values from each dico and paste them on another sheet named > ReportSheet