I had this question after viewing Using the Dictionary Class in VBA
I am attempting to sort data into dictionaries based off of several requirements. The difficulty I face is that the "Unique" key is really a culmination of several different columns. The reason I want the dictionary structure is because it give me the ability to query based of the subsets of the keys. Example: The total Unique key would be Product&Store#&Day&Time which I could use to find the # of Product I sold on Friday between 1 & 3 PM @ store 1, but using the dictionary inside of a dictionary etc. I could quickly ask how many of Product A did I sell in total, how many of Product A do I sell on Fridays and so forth. Ideally I would be able to put upwards of 5 dictionaries together.
When I attempt to use the format laid out in this article, I keep running into the problem where keys already exist or the key doesn't exist causing the code to stop.
Thank you. I can not attach an article due to the sensitive nature of the data.