connecting Shapes by reading table

Hello, i'm trying to create a macro that reads a solution matrix data, and represent the solution visually by connecting shapes using connectors.

In sheet1 i have the shapes i need to connect and in sheet2 i have the data matrix that needs to be read. The connection needs to have a beginning, represented by "reflow1" matrix and an ending represented by "reflow2" matrix.

the code is in module2 of VBA, and is currently working, though the assignments are not correct.( it should assign k=* between reflow1 and reflow2 in the corresponding smd). For example k=6 should create a connection between smd 21 and smd 6.

I have tried several times, but can't get the connections right. Any help would be appreciated.

Attachment 631211
Attachment 631212

Hi, welcome (bemvindo) to the forum,
I'll take a look and see if I can help, let met see if I understand your question first.

Can you explain what smd stands for?
Why did you not name every rectangle smd and the number, smd 18 you named Rectangle 1 why not directly smd1 as shape, makes it easier to address?
How do you know the smd(18) =1 if you just name that one smd1 or smd01 will make it easier than an array and you have to think it all out.
Think it over

Correction, smd will not be accepted since its a column, but you coud think of something else like rect1 and then the caption smd1 or 01?

Okay, understood, but why not give the shapes the same number makes it easier to relate to.
So smd 18 rectangle 18 then you can relate easier than the then to think 18? with rectangle?

Now the rectangles have the same name as the machine

I played around with my idea and it works quite well. I removed the smd array and clear the connection lines before starting.
Give it a try

I noticed you marked this post SOLVED, but did it work for you?
You could at least have the decency to say something like thank you obrigado.