Hey All,

I currently have a program in which I have 12 lists (list_1, list_2, list_3...). I am iterating through some data, and, based on some criteria, the data goes into one of the 12 lists.

While iterating through the data, I have a counter that goes from 1 to 12 that indicates which list the data should go into.

Obviously, I could hard code all 12 lists; however, is there a way I could use a string to reference the list?


Example of what I am attempting to do. (NOTE: I do not want to hard code each of the 12 lists):


iterator = 1

for each cell in data

    "list_" & iterator = cell.value

    iterator = iterator + 1
    if iterator >12 then
       iterator = 1

next