Matrix to Table

Hi All,

I'm looking for a script to create a datalist based upon the tab "Requirement" combined with the Bill Of Material of the tab BoM.

Example is in the Total tab

Try the attached.

Please Login or Register  to view this content.

sir jindon what the mean this code

Please Login or Register  to view this content.

Not interested in replying to a question from someone who ignores/makes no response.

http://www.excelforum.com/excel-prog...ncatenate.html

That line is to output the corresponding data stored in Dictionary

Please Login or Register  to view this content.

to output array "b".

Sir jindon i has use for loop without array
Data in col a:d
I want unique in col a dan sub unique in col b:d
But still error sorri not in mark #
Sub tes ()
Dim d as object : set d = createobject("scripting.dictionary")
For each r in columns(1).specialcells(2)
If not d. Exists(r.value) then
d.add r. Value, array(r.offset(,1),r. Offset(,2),r. Offset(,3))
Else
d.item(r.value) = d.item(r.value), array(r.offset(,1),r. Offset(,2),r. Offset(,3)).value
End if
Next
For each v in d. Keys
n=1:n=n+1
range("a" & n) = v
Range("b" & n) = d(v)
Next
End sub

But i has not sukses











Next

Works super Jindon!

Thankyou for attention mr. Jindon the problem solve..i hope your point will be up thank from triak..and bembeng