Anonymous
4597 Views, 13 Replies
02-06-2016
09:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
02-06-2016
09:12 AM
please help! i'm stuck ![]()
here is a simplified example of what i am trying to do...
i trying to create multiple MultiValue.List from Excel, and here is a small snippet that i know works...
MultiValue.SetList("SIZE", "SIZE-AA", "SIZE-BB", "SIZE-CC")
If SIZE = "SIZE-AA" Then
GoExcel.TitleRow = 2
MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A3", "A5")
ElseIf SIZE = "SIZE-BB" Then
GoExcel.TitleRow = 7
MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A8", "A10")
ElseIf SIZE = "SIZE-CC" Then
GoExcel.TitleRow = 12
MultiValue.List("MODEL") = GoExcel.CellValues("filename.xls", "Sheet1", "A13", "A15")
End Ifso now, what i would like to do is create another MultiValue.List from the first MultiValue.List.
for example, if i select "SIZE-AA" from my "SIZE" multi-list (SIZE-AA, SIZE-BB, SIZE-CC), my next list from "MODEL" would give me "AA100, AA110, AA210", then my next list for eg. "AA110" would be "10, 20, 30,40".
can this even be done?
thanks
Solved! Go to Solution.