Brain teaser. Please I need help anybody. My vba coding nightmare

[Russellsky]

I have been playing around for a while now but no matter how hard I try I just can't get my vba coding to work for what I'm trying to do. I have had some limited success with match and index and then removing duplicates witch seemed to give me almost what I needed.
Ok
so this is what I'm trying to do. I have a item number in coloum A. In coloum B There is a also a item. There is spacer number that is found inbetween
the items in coloum A and B .What makes it tricky is there are up to 4 sides
to the item in colume A. And also there is a possibility that there might be up to
two different spacers per item and iten numbers arnt in order

A. B. C.
14. 15. Xcv
15. 14. Zen
15. 16. Nui
13. 15. Agh
12. 15. Lob
17. 16. Yip
17. 18. Why


what I need to get out is coloum A and a list of all the items B C D E are The adjacent items

A. B. C. D. E.
15. 14. 12. 16. 13.
16. 17. 18
18. 17.
14. 15.
12. 15
17. 16
18. 17


If if anybody has any idea how to create a macro to do this. please please help. Im manually doing this at the moment and have 30000 to still do

 

[hiker95]

Russellsky,

I am confused at what I see in your reply #9, and, your reply #10.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[Russellsky]

Bump