Dictionary - Using a dictionary of dictionaries to hold individual orders

hi

i have had a go at trying to develop the above, but my limited knowledge of dictionaries is holding me back!

What im trying to do is as follows. I have a worksheet with several rows of data spanning 6 columns. The fourth column contains a batch code, which may be repeated on other rows. I need to use this batch code as an order number for all rows that have it.

So, i use a collection to get all the unique batch numbers in the sheet, and for each one, i want to create a dictionary with the batch code as the key and an array of rows as the item. This forms one order, and i want to write it to another worksheet later.

I then want to collect these individual orders into another dictionary, which im hoping i can loop over later to read out the individual orders. The problem im having is, i cant see the arrays saved in the dictionaries (or i just dont know how to), and dont know the best way to iterate over them.

I can visualise what im trying to achieve, but dont know if im going about this the right way or if theres a better way, so i would appreciate some help. My attempt at this is attached.

thanks

Please Login or Register  to view this content.

If you upload a small sample file clearly showing before/after, it will be easier to understand what you are trying to do.