Generate data with all combinations
excellent. thanks
"Gary''s Student" wrote:
Sub Venkatesh()
sec = Array("sec1", "sec2", "sec3", "sec4")
acc = Array(1, 2, 3, 4, 5, 6, 7, 8)
tipe = Array("t1", "t2", "t3", "t4")
L = 1
For i = 0 To 3
For j = 0 To 7
For k = 0 To 3
Cells(L, 1).Value = sec(i)
Cells(L, 2).Value = acc(j)
Cells(L, 3).Value = tipe(k)
L = L + 1
Next
Next
Next
End Sub
Naturally, put your own values in the array statements.
--
Gary''s Student - gsnu200816
"Venkatesh V" wrote:
HI,
Please provide help on how to generate data on all comibinations
in an excel I have 3 clumns
Sec - has 4 values
Acc - has 8 values
Type - 4 values
with the available data, i reuqire either an addin or macro or any tiool
that would generate data will all the combinations of values
so, with the above example - excel shoud have: 4 * 8* 4 =128 rows in excel.
how to do it?
Thanks,
Venkat
|