+ Reply to Thread
Results 1 to 3 of 3

Dictionary - Using a dictionary of dictionaries to hold individual orders

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    87

    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.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Dictionary - Using a dictionary of dictionaries to hold individual orders

    You could instead sort and autofilter by batch number.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,465

    Re: Dictionary - Using a dictionary of dictionaries to hold individual orders

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating Dictionary of Dictionaries
    By Dodo123 in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 03-02-2014, 11:30 AM
  2. Multiple Dictionaries Or One Dictionary
    By goss in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-15-2012, 07:58 AM
  3. vba dictionary
    By kieranbop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2011, 06:06 AM
  4. HELP-Dictionary
    By dfisch8 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2005, 04:05 PM
  5. [SOLVED] Dictionary
    By Jac Tremblay in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1