Russellsky
New Member
- Joined
- Aug 31, 2015
- Messages
- 12
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 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 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 please please help. Im manually doing this at the moment and have 30000 to still do
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 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 please please help. Im manually doing this at the moment and have 30000 to still do
