Hi guys - wonder if you can help.
I have a loop within a loop - the inner loop gets the values in certain cells and calls them d, this value is then stored in a string. The string is added to until there is no more data to add - it becomes a list. The problem is that i want to put an outside loop in that creates a different list each time but all the lists remain stored. In othere words i am looking for a bit of code to call the list e.g list a where a is 1 and changes by one each time the loop executes AT the end therefore i may have 3 lists each named list1, list2 and list3. Hope this makes sense. Any ideas, thanks

z = 2
Do Until z = (x - 1)
c = 0
y = 1
Do Until c = 1
If Worksheets(1).Cells(z, (y + 1)) = Empty Then
c = 1
'z = (x - 2)
End If
d = Worksheets(1).Cells(z, (y + 1))
list_sen = list_sen & d & ", "
y = y + 1
Loop
z = z + 1
Loop