VBa autocad drawing

I have a vba macro, that creates a drawing in autocad. I got the sample worksheet from a site, and fixed all the errors I had after modifying it, but the result is not what I need, since the drawing's a mess, and it has multiple lines and it closes in a way that shouldn't be. I need the drawing to join multiple points, but some coordinates repeat themselves, since I am looking for a match in column A that matches a cell in column B. If there is a match, I need to get the row number and use that number to get the xyz coordinates for the point. Then, I need to plot all those points in an autocad drawing. I will share the sample workbook, and my curreny workbook, so you can start the job. Thanks in advance.